------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\Users\Yanan and Ben\Desktop\NHPI-exercise Replication Package\20250822-brfss2017-dataprep.log
  log type:  text
 opened on:  25 Aug 2025, 04:49:26
r; t=0.02 4:49:26

. version 15.1
r; t=0.01 4:49:26

. clear   all
r; t=0.06 4:49:26

. macro   drop _all
r; t=0.00 4:49:26

. set     linesize 80
r; t=0.00 4:49:26

. set     scheme plottig
r; t=0.00 4:49:26

. set             more off
r; t=0.00 4:49:26

. set             varabbrev off
r; t=0.00 4:49:26

. set     rmsg on
r; t=0.00 4:49:26

. 
. // #0. Document this do-file
.         local today : di %tdCY/N/D daily("$S_DATE", "DMY")
r; t=0.00 4:49:26

.         tokenize `today',parse("/")
r; t=0.00 4:49:26

.         local year `1'
r; t=0.00 4:49:26

.         local month `3'
r; t=0.00 4:49:26

.         local day `5'
r; t=0.00 4:49:26

. 
.         local who "Ben Cheung"
r; t=0.00 4:49:26

.         local pgm "20250822-brfss2017-dataprep"
r; t=0.00 4:49:26

.         local date "`year'-`month'-`day'"
r; t=0.00 4:49:26

.         local tag "`pgm'.do by `who' on `date'"
r; t=0.00 4:49:26

.         display "The tag is: `tag'"
The tag is: 20250822-brfss2017-dataprep.do by Ben Cheung on 2025-08-25
r; t=0.00 4:49:26

. 
. 
.         local today : di %tdCYND daily("$S_DATE", "DMY")
r; t=0.00 4:49:26

. 
. 
.         *Check for installed packages
.         capture which scheme-plottig.scheme
r; t=0.00 4:49:26

.         if _rc!=0 ssc install blidschemes
r; t=0.00 4:49:26

. 
.         capture which confirmdir
r; t=0.00 4:49:26

.         if _rc!=0 ssc install confirmdir
r; t=0.00 4:49:26

. 
.         capture which estout
r; t=0.01 4:49:26

.         if _rc!=0 ssc install estout
r; t=0.00 4:49:26

. 
.         capture which sum2docx
r; t=0.00 4:49:26

.         if _rc!=0 ssc install sum2docx
r; t=0.00 4:49:26

. 
.         capture which tab2xl
r; t=0.02 4:49:26

.         if _rc!=0 net install http://www.stata.com/users/kcrow/tab2xl, replace
r; t=0.00 4:49:26

. 
.         set scheme plottig
r; t=0.00 4:49:26

. 
. 
. local folder "Original data"
r; t=0.00 4:49:26

. confirmdir "`folder'"
r; t=0.00 4:49:26

. if `r(confirmdir)'==170 {
.         mkdir "`folder'"
r; t=0.00 4:49:26
. }
r; t=0.00 4:49:26

. 
. 
. 
. local folder "Data Ready for Analysis"
r; t=0.00 4:49:26

. confirmdir "`folder'"
r; t=0.00 4:49:26

. if `r(confirmdir)'==170 {
.         mkdir "`folder'"
r; t=0.00 4:49:26
. }
r; t=0.00 4:49:26

. 
. 
. 
. 
. *Define custom program to show command in loop
. program define pe
  1.         version 15.1
  2.         if `"`0'"' != "" {
  3.                 display("")
  4.                 display as input `". `0'"'
  5.                 `0'
  6.                 display("")
  7.         }
  8. end
r; t=0.00 4:49:26

. 
. 
. 
. 
. 
. // #1. Data management
. import sasxport "Original Data/LLCP2017.XPT",clear
r; t=57.27 4:50:23

. 
. 
. 
. 
. // #2. Data management
. *Survey setup in Stata: https://www.cdc.gov/copd/pdfs/BRFSS_COPD_Syntax.pdf
. 
. *calculated variables for race vary across years:
. *_racegr (1993-2000): 1=Non-hispanic white, 2=Non-hispanic black, 3=Hispanic, 
> 4=Other, 9=missing (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00
> .pdf)
. *_racegr2 (2001-2012): 1=Non-hispanic white, 2=Non-hispanic black, 3=Non-hispa
> nic other, 4=Non-hispanic multiracial, 5=Hispanic, 9=missing (https://www.cdc.
> gov/brfss/annual_data/2001/pdf/codebook_01.pdf)
. *_racegr3 (2013-2019): 1=Non-hispanic white, 2=Non-hispanic black, 3=Non-hispa
> nic other, 4=Non-hispanic multiracial, 5=Hispanic, 9=missing (https://www.cdc.
> gov/brfss/annual_data/2019/pdf/codebook19_llcp-v2-508.HTML)
. 
. 
. *race (1993-2000): 1=Non-hispanic white, 2=Non-hispanic black, 3=Hispanic-whit
> e, 4=Hispanic-black, 5=Other hispanic, 6=Non-hispanic asian/Pacific Islander, 
> 7=Non-hispanic Native American, 8=Non-hispanic other, 9=missing (https://www.c
> dc.gov/brfss/annual_data/1993/pdf/layout93.pdf)
. *race2 (2001-2012): 1=Non-hispanic white, 2=Non-hispanic black, 3=Non-hispanic
>  asian, 4=Non-hispanic Native Hawaiian/Pacific Islander, 5=Non-hispanic Native
>  American, 6=Non-hispanic other, 7=Non-hispanic multiracial, 8=Hispanic, 9=mis
> sing (https://www.cdc.gov/brfss/annual_data/2001/pdf/riskfactor_01.pdf)
. *_race (2013-2019): 1=Non-hispanic white, 2=Non-hispanic black, 3=Non-hispanic
>  Native American, 4=Non-hispanic asian, 5=Non-hispanic Native Hawaiian/Pacific
>  Islander, 6=Non-hispanic other, 7=Non-hispanic multiracial, 8=Hispanic, 9=mis
> sing (https://www.cdc.gov/brfss/annual_data/2013/pdf/2013_calculated_variables
> _version15.pdf)
. 
. 
. *Starting from 2001, Hispanic was no longer further partitioned into different
>  racial groups (i.e., Hispanic-black, Hispanic-white...).
. *Since I need to construct Hispanic non-black and Hispanic Black as two racial
> /ethnic groups in the data, I need to obtain the original racial and ethnic gr
> oups variables to compute these two groups myself.
. *_prace (2001-2012): 1=White, 2=Black/African American, 3=Asian, 4=Native Hawa
> iian/Pacific Islander, 5=American Indian/Alaskan Native, 6=Other, 7=No preferr
> ed race, 8=Multiracial but no preferred race, 77=Don't know/not sure, 99=Refus
> ed (https://www.cdc.gov/brfss/annual_data/2001/pdf/codebook_01.pdf)
. *_prace1 (2013-2019): 1=White, 2=Black/African American, 3=American Indian/Ala
> skan Native, 4=Asian, 5=Native Hawaiian/Pacific Islander, 6=Other, 7=No prefer
> red race, 8=Multiracial but no preferred race, 77=Don't know/not sure, 99=Refu
> sed (https://www.cdc.gov/brfss/annual_data/2013/pdf/CODEBOOK13_LLCP.pdf)
. *hispanc2 (2001-2012): 1=Yes, 2=No, 7=Don't know/not sure, 9=Refused (https://
> www.cdc.gov/brfss/annual_data/2001/pdf/codebook_01.pdf)
. *_hispanc (2013-2019): 1=Hispanic/Latino/Spanish origin, 2=Not of Hispanic/Lat
> ino/Spanish origin, 9=Don't know/refused (https://www.cdc.gov/brfss/annual_dat
> a/2013/pdf/CODEBOOK13_LLCP.pdf)
. 
. 
. 
. *survey weight:
. *_finalwt (1993-2010): 9999999999=unknown (https://www.cdc.gov/brfss/annual_da
> ta/1993/pdf/layout93.pdf)
. *_llcpwt (2011-2019): (https://www.cdc.gov/brfss/annual_data/2011/pdf/BRFSS201
> 1_Analysis.pdf)
. 
. 
. *strata:
. *_ststr (1993-2019)
. 
. *PSU:
. *_psu (1993-2019)
. 
. *Questionnaire version:
. *_qstver (1997-2001): 1=Version 1, 2=Version 2, BLANK=Not applicable (https://
> www.cdc.gov/brfss/annual_data/1997/files/CODEBK97.TXT)
. *_qstver (2002): No documentation and the categories are weird (https://www.cd
> c.gov/brfss/annual_data/2002/pdf/codebook_02.pdf)
. *qstver (2003): 1=Version 1, 2=Version 2, BLANK=Missing (https://www.cdc.gov/b
> rfss/annual_data/2003/pdf/Codebook_03.pdf)
. *qstver (2004-2007): 0=Only version, 1=Version 1, 2=Version 2, BLANK=Missing (
> https://www.cdc.gov/brfss/annual_data/2004/pdf/Codebook_04.pdf)
. *qstver (2009): 0=Only version, 1=Version 1, 2=Version 2, 3=Version 3, BLANK=M
> issing (https://www.cdc.gov/brfss/annual_data/2008/pdf/codebook08.pdf)
. *qstver (2010): 10=Only version, 11=Version 1, 12=Version 2, 13=Version 3 (htt
> ps://www.cdc.gov/brfss/annual_data/2010/pdf/codebook_10.pdf)
. *qstver (2011): 10=Only version, 11=Version 1, 12=Version 2, 13=Version 3, 20=
> Only Version Cell Phone (https://www.cdc.gov/brfss/annual_data/2011/pdf/CODEBO
> OK11_LLCP.pdf)
. *qstver (2012-2019): 10=Only version, 11=Version 1, 12=Version 2, 13=Version 3
> , 20=Only Version Cell Phone, 21=Version 1 Cell Phone, 22=Version 2 Cell Phone
> , 23=Version 3 Cell Phone (https://www.cdc.gov/brfss/annual_data/2012/pdf/CODE
> BOOK12_LLCP.pdf)
. 
. 
. 
. *age:
. *age (1993-2012): 07=Don't know/not sure, 09=Refused
. *_age80 (2013-2019): imputed age from 18 to 80
. 
. 
. *employment status:
. *employ (1993-2012):1=Employed, 2=Self-employed, 3=Out of work for more than 1
>  year, 4=Out of work for less than 1 year, 5=Homemaker, 6=Student, 7=Retired, 
> 8=Unable to work, 9=Refused (https://www.cdc.gov/brfss/annual_data/1993/pdf/la
> yout93.pdf)
. *employ1 (2013-2019):1=Employed, 2=Self-employed, 3=Out of work for 1 year or 
> more, 4=Out of work for less than 1 year, 5=Homemaker, 6=Student, 7=Retired, 8
> =Unable to work, 9=Refused (https://www.cdc.gov/brfss/annual_data/2013/pdf/COD
> EBOOK13_LLCP.pdf)
. 
. *sex:
. *sex (1993-2017): 1=Male, 2=Female, 9=Refused (https://www.cdc.gov/brfss/annua
> l_data/1993/pdf/layout93.pdf)
. *sex1 (2018): 1=Male, 2=Female, 7=Don't know/not sure, 9=Refused (https://www.
> cdc.gov/brfss/annual_data/2018/pdf/codebook18_llcp-v2-508.pdf)
. *sexvar (2019): 1=Male, 2=Female (https://www.cdc.gov/brfss/annual_data/2019/p
> df/codebook19_llcp-v2-508.HTML)
. 
. 
. *SRH:
. *genhlth: 1=Excellent, 2=Very good, 3=Good, 4=Fair, 5=Poor, 7=Don't know/not s
> ure, 9=Refused (https://www.cdc.gov/brfss/annual_data/1993/pdf/layout93.pdf)
. *In 1996, Tennessee (FIPS: 47) didn't ask the SRH question.
. 
. *Number of days in last month with not good physical health:
. *physhlth: 1, 2, 3... 30 days, 77=Don't know/not sure, 88=None, 99=Refused (ht
> tps://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. 
. *Number of days in last month with not good mental health:
. *menthlth: 1, 2, 3... 30 days, 77=Don't know/not sure, 88=None, 99=Refused (ht
> tps://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. 
. *Number of days in last month keeping R from usual activities due to poor phys
> ical/mental health:
. *poorhlth: 1, 2, 3... 30 days, 77=Don't know/not sure, 88=None, 99=Refused (ht
> tps://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. 
. 
. *Asthma (ever told by doctor you have asthma):
. *asthma (1999-2000): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=skip
> ped (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *asthma2 (2001-2010): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=ski
> pped or missing (https://www.cdc.gov/brfss/annual_data/2004/pdf/Codebook_04.pd
> f)
. *asthma3 (2011-2019): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused (https://w
> ww.cdc.gov/brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. 
. *Cholesterol (ever told by doctor you have high blood cholesterol):
. *toldhi (1993-2000): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused (https://ww
> w.cdc.gov/brfss/annual_data/1993/pdf/layout93.pdf)
. *toldhi2 (2001-2005, 2007, 2009, 2011, 2013, 2015, 2017, 2019): 1=Yes, 2=No, 7
> =Don't know/Not sure, 9=Refused (https://www.cdc.gov/brfss/annual_data/2001/pd
> f/codebook_01.pdf)
. 
. *Heart attack (ever told by doctor you have heart attack) (asked by all states
>  since 2005):
. *cvdinfar (1996-2000): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *cvdinfr2 (2001-2004): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2001/pdf/codebook_01.pdf)
. *cvdinfr3 (2005-2006): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2006/pdf/codebook_06.pdf)
. *cvdinfr4 (2007-2019): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2012/pdf/CODEBOOK12_LLCP.pdf)
. 
. 
. *Coronary heart disease (ever told by doctor you have coronary heart disease) 
> (asked by all states since 2005):
. *cvdcorhd (1996-2000): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *cvdcrhd2 (2001-2004): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2001/pdf/codebook_01.pdf)
. *cvdcrhd3 (2005-2006): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2006/pdf/codebook_06.pdf)
. *cvdcrhd4 (2007-2019): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2012/pdf/CODEBOOK12_LLCP.pdf)
. 
. 
. *Stroke (ever told by doctor you have stroke) (asked by all states since 2005)
> :
. *cvdstrok (1996-2000): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *cvdstrk2 (2001-2004): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2001/pdf/codebook_01.pdf)
. *cvdstrk3 (2005-2019): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2006/pdf/codebook_06.pdf)
. 
. 
. *Diabetes (ever told by doctor you have diabetes):
. *diabetes (1993): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused (https://www.c
> dc.gov/brfss/annual_data/1993/pdf/layout93.pdf)
. *diabetes (1994-2003): 1=Yes, 2=Yes but during pregnancy, 3=No, 7=Don't know/N
> ot sure, 9=Refused (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00
> .pdf)
. *diabete2 (2004-2010): 1=Yes, 2=Yes but during pregnancy, 3=No, 4=borderline d
> iabetes, 7=Don't know/Not sure, 9=Refused, BLANK=skipped or missing (https://w
> ww.cdc.gov/brfss/annual_data/2004/pdf/Codebook_04.pdf)
. *diabete3 (2011-2018): 1=Yes, 2=Yes but during pregnancy, 3=No, 4=borderline d
> iabetes, 7=Don't know/Not sure, 9=Refused, BLANK=skipped or missing (https://w
> ww.cdc.gov/brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. *diabete4 (2019): 1=Yes, 2=Yes but during pregnancy, 3=No, 4=borderline diabet
> es but during pregnancy, 7=Don't know/Not sure, 9=Refused, BLANK=skipped or mi
> ssing (https://www.cdc.gov/brfss/annual_data/2019/pdf/codebook19_llcp-v2-508.H
> TML)
. 
. 
. *High blood pressure (ever told by doctor you have high blood pressure):
. *bphigh (1993-2000): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=skip
> ped (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *bphigh2 (2001): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=skipped 
> (https://www.cdc.gov/brfss/annual_data/2001/pdf/codebook_01.pdf)
. *bphigh3 (2002-2004): 1=Yes, 2=Yes but during pregnancy, 3=No, 7=Don't know/No
> t sure, BLANK=skipped (https://www.cdc.gov/brfss/annual_data/2004/pdf/Codebook
> _04.pdf)
. *bphigh4 (2005, 2007, 2009, 2011, 2013, 2015, 2017, 2019): 1=Yes, 2=Yes but du
> ring pregnancy, 3=No, 4=borderline high, 7=Don't know/Not sure, 9=Refused, BLA
> NK=skipped (https://www.cdc.gov/brfss/annual_data/2017/pdf/codebook17_llcp-v2-
> 508.pdf)
. 
. 
. *last routine checkup:
. *checkup (1993-2002, 2005-2006): 1=1 to 12 months ago, 2=1 to 2 years ago, 3=2
>  to 5 years ago, 4=5 or more years ago, 7=Don't know/not sure, 8=Never, 9=Refu
> sed (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *checkup1 (2007-2019): 1=less than 12 months ago, 2=1 to less than 2 years ago
> , 3=2 to less than 5 years ago, 4=5 or more years ago, 7=Don't know/not sure, 
> 8=Never, 9=Refused (https://www.cdc.gov/brfss/annual_data/2011/pdf/CODEBOOK11_
> LLCP.pdf)
. 
. 
. *******************Alcohol drinking questions start*******************
. *Any alcohol drinking in past 30 days:
. *drinkany (1993-2000): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *(no such question in 2001-2004, since it was combined with alcdays and alcday
> 3. There were calculated variables based on alcdays and alcday3)
. *drnkany4 (2005-2010): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2005/pdf/Codebook_05.pdf)
. *no such question in 2010-2019, since it was combined with alcdays and alcday3
> . There were calculated variables based on alcday5)
. 
. 
. *Days of alcohol drinking in the last 30 days (asked by all states since 2001)
> :
. *alcohol (1993-2000): 101-107=Number of days per week (1 indicates weekly numb
> er), 201-231= Number of days per month (2 indicates monthly number), 777=Don't
>  know/Not sure, 999=Refused, BLANK=skipped (https://www.cdc.gov/brfss/annual_d
> ata/2000/pdf/codebook_00.pdf)
. *alcdays (2001): 101-107=Number of days per week (1 indicates weekly number), 
> 201-230= Number of days per month (2 indicates monthly number), 777=Don't know
> /Not sure, 888=No drink, 999=Refused, BLANK=skipped (https://www.cdc.gov/brfss
> /annual_data/2001/pdf/codebook_01.pdf)
. *alcday3 (2002-2004): 101-107=Number of days per week (1 indicates weekly numb
> er), 201-230= Number of days per month (2 indicates monthly number), 777=Don't
>  know/Not sure, 888=No drink, 999=Refused, BLANK=skipped (https://www.cdc.gov/
> brfss/annual_data/2002/pdf/codebook_02.pdf)
. *alcday4 (2005-2010): 101-107=Number of days per week (1 indicates weekly numb
> er), 201-230= Number of days per month (2 indicates monthly number), 777=Don't
>  know/Not sure, 888=No drink, 999=Refused, BLANK=skipped (https://www.cdc.gov/
> brfss/annual_data/2010/pdf/codebook_10.pdf)
. *alcday5 (2011-2019): 101-107=Number of days per week (1 indicates weekly numb
> er), 201-230= Number of days per month (2 indicates monthly number), 777=Don't
>  know/Not sure, 888=No drink, 999=Refused, BLANK=skipped (https://www.cdc.gov/
> brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. *******************Alcohol drinking questions end*******************
. 
. 
. 
. 
. *******************Smoking questions start*******************
. *Ever smoked at least 100 cigarettes in life:
. *smoke100 (1993-2019): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/1993/pdf/layout93.pdf)
. 
. 
. 
. *Currently a smoker or not:
. *smokenow (1993-1995): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/1995/pdf/layout95.pdf)
. *smokeday (1996-2004): 1=Everyday, 2=Some days, 3=Not at all, 9=Refused, BLANK
> =skipped (https://www.cdc.gov/brfss/annual_data/1996/files/CODEBK96.TXT)
. *smokday2 (2005-2019): 1=Everyday, 2=Some days, 3=Not at all, 7=Don't know/Not
>  sure, 9=Refused, BLANK=skipped (https://www.cdc.gov/brfss/annual_data/2005/pd
> f/Codebook_05.pdf)
. 
. 
. *Number of cigarettes now smoke per day:
. *smokenum (1993-2000): 1-87= Number of cigarettes (1 pack=20 cigarettes), 88=D
> on't smoke, 99=Refused (https://www.cdc.gov/brfss/annual_data/1993/pdf/layout9
> 3.pdf)
. *(This question was not asked since 2001)
. *******************Smoking questions end*******************
. 
. 
. 
. *******************Fruit and vegetables questions start*******************
. *How often drink fruit juice?
. *fruitjui (1994, 1996, 1998, 2000, 2002, 2003, 2005, 2007, 2009): 101-199=per 
> day, 201-299=per week, 301-399=per month, 401-499=per year, 555=Never, 777=Don
> ’t know/not sure, 999=Refused (https://www.cdc.gov/brfss/annual_data/2005/pdf/
> Codebook_05.pdf)
. *fruitju1 (2011-2013, 2015): 101-199=per day, 201-299=per week, 300=Less than 
> one time per month, 301-399=per month, 555=Never, 777=Don’t know/not sure, 999
> =Refused (https://www.cdc.gov/brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. *fruitju2 (2017, 2019): 101-199=per day, 201-299=per week, 300=Less than one t
> ime per month, 301-399=per month/year, 555=Never, 777=Don’t know/not sure, 999
> =Refused (https://www.cdc.gov/brfss/annual_data/2017/pdf/codebook17_llcp-v2-50
> 8.pdf)
. 
. *How often eat fruit?
. *fruit (1994, 1996, 1998, 2000, 2002, 2003, 2005, 2007, 2009): 101-199=per day
> , 201-299=per week, 301-399=per month, 401-499=per year, 555=Never, 777=Don’t 
> know/not sure, 999=Refused (https://www.cdc.gov/brfss/annual_data/2005/pdf/Cod
> ebook_05.pdf)
. *fruit1 (2011, 2013, 2015): 101-199=per day, 201-299=per week, 300=Less than o
> ne time per month, 301-399=per month, 555=Never, 777=Don’t know/not sure, 999=
> Refused (https://www.cdc.gov/brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. *fruit2 (2017, 2019): 101-199=per day, 201-299=per week, 300=Less than one tim
> e per month, 301-399=per month, 555=Never, 777=Don’t know/not sure, 999=Refuse
> d (https://www.cdc.gov/brfss/annual_data/2017/pdf/codebook17_llcp-v2-508.pdf)
. 
. *How often eat green salad?
. *greensal (1994, 1996, 1998, 2000, 2002, 2003, 2005, 2007, 2009): 101-199=per 
> day, 201-299=per week, 301-399=per month, 401-499=per year, 555=Never, 777=Don
> ’t know/not sure, 999=Refused (https://www.cdc.gov/brfss/annual_data/2005/pdf/
> Codebook_05.pdf)
. 
. *How often eat potatoes (not fried)?
. *potatoes (1994, 1996, 1998, 2000, 2002, 2003, 2005, 2007, 2009): 101-199=per 
> day, 201-299=per week, 301-399=per month, 401-499=per year, 555=Never, 777=Don
> ’t know/not sure, 999=Refused (https://www.cdc.gov/brfss/annual_data/2005/pdf/
> Codebook_05.pdf)
. 
. *How often eat carrots?
. *carrots (1994, 1996, 1998, 2000, 2002, 2003, 2005, 2007, 2009): 101-199=per d
> ay, 201-299=per week, 301-399=per month, 401-499=per year, 555=Never, 777=Don’
> t know/not sure, 999=Refused (https://www.cdc.gov/brfss/annual_data/2005/pdf/C
> odebook_05.pdf)
. 
. *How often eat vegetables?
. *vegetables (1994, 1996, 1998, 2000, 2002, 2003, 2005, 2007, 2009): 101-199=pe
> r day, 201-299=per week, 301-399=per month, 401-499=per year, 555=Never, 777=D
> on’t know/not sure, 999=Refused (https://www.cdc.gov/brfss/annual_data/2005/pd
> f/Codebook_05.pdf)
. 
. *Number of daily servings of fruits and vegetables
. *_frtserv (1994): 0-999.98=numbers of times per day, 999.99=Don’t know/refused
> /missing (https://www.cdc.gov/brfss/annual_data/1994/pdf/layout94.pdf)
. *_frtserv (1996, 1998, 2000, 2002, 2003, 2005, 2007, 2009): 0-99998=numbers of
>  times per day, 99999=Don’t know/refused/missing (last two digits correspond t
> o two decimal places) (https://www.cdc.gov/brfss/annual_data/1996/files/CODEBK
> 96.TXT)
. 
. *Number of fruit consumed per day (the two following variables' last one digit
>  should correspond to one decimal place, but the codebook mis-stated that the 
> last two digits correspond to two decimal places)
. *_frutsum (2011, 2013, 2015): 0-99998=number of times per day, Blank=not asked
> /missing (last one digit correspond to one decimal place) (https://www.cdc.gov
> /brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. *_frutsu1 (2017, 2019): 0-99998=number of times per day, Blank=not asked/missi
> ng (last one digit correspond to one decimal place) (https://www.cdc.gov/brfss
> /annual_data/2017/pdf/codebook17_llcp-v2-508.pdf)
. 
. *Number of vegetables consumed per day (the two following variables' last one 
> digit should correspond to one decimal place, but the codebook mis-stated that
>  the last two digits correspond to two decimal places)
. *_vegesum (2011, 2013, 2015): 0-99998=number of times per day, Blank=not asked
> /missing (last one digit correspond to one decimal place) (https://www.cdc.gov
> /brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. *_vegesu1 (2017, 2019): 0-99998=number of times per day, Blank=not asked/missi
> ng (last one digit correspond to one decimal place) (https://www.cdc.gov/brfss
> /annual_data/2017/pdf/codebook17_llcp-v2-508.pdf)
. *******************Fruit and vegetables questions end*******************
. 
. 
. *Flu shot last year?
. *flushot (1993, 1995, 1997, 1999, 2001-2003): 1=Yes, 2=No, 7=Don’t know/not su
> re, 9=Refused, Blank=Skipped (https://www.cdc.gov/brfss/annual_data/2003/pdf/C
> odebook_03.pdf)
. *flushot2 (2004): 1=Yes, 2=No, 7=Don’t know, 9=Refused (https://www.cdc.gov/br
> fss/annual_data/2004/pdf/Codebook_04.pdf)
. *flushot3 (2005-2009): 1=Yes, 2=No, 7=Don’t know, 9=Refused (https://www.cdc.g
> ov/brfss/annual_data/2005/pdf/Codebook_05.pdf)
. *flushot4 (2010): 1=Yes, 2=No, 7=Don’t know, 9=Refused, Blank=Not asked or mis
> sing (https://www.cdc.gov/brfss/annual_data/2010/pdf/codebook_10.pdf)
. *flushot5 (2011-2012): 1=Yes, 2=No, 7=Don’t know, 9=Refused, Blank=Not asked o
> r missing (https://www.cdc.gov/brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. *flushot6 (2013-2018): 1=Yes, 2=No, 7=Don’t know, 9=Refused, Blank=Not asked o
> r missing (https://www.cdc.gov/brfss/annual_data/2013/pdf/CODEBOOK13_LLCP.pdf)
. *flushot7 (2019): 1=Yes, 2=No, 7=Don’t know, 9=Refused, Blank=Not asked or mis
> sing (https://www.cdc.gov/brfss/annual_data/2019/pdf/codebook19_llcp-v2-508.HT
> ML)
. 
. 
. *Seat belt usage
. *seatbelt (1993, 1995, 1997, 2002, 2006, 2008, 2010-2018): 1=Always, 2=Nearly 
> always, 3=Sometimes, 4=Seldom, 5=Never, 7=Don’t know/not sure, 8=Never drive o
> r ride in a car, 9=Refused, Blank=Skipped (https://www.cdc.gov/brfss/annual_da
> ta/2018/pdf/codebook18_llcp-v2-508.pdf)
. 
. 
. 
. *physical activities in last month:
. *exerany (1993-2000): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=ski
> pped (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *exerany2 (2001-2019): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2017/pdf/codebook17_llcp-v2-508.p
> df)
. 
. 
. *medcost (Was there a time during the last 12 months when you needed to see a 
> doctor, but could not because of the cost?):
. *medcost (1993-2001, 2003-2019): 1=Yes, 2=No, 7=Don't know/not sure, 9=Refused
>  (https://www.cdc.gov/brfss/annual_data/1993/pdf/layout93.pdf)
. 
. *healthcare plan (Do you have any kind of health care coverage, including heal
> th insurance, prepaid plans such as HMOs, or government plans such as Medicare
> ?):
. *hlthplan (1993-2010): 1=Yes, 2=No, 7=Don't know/not sure, 9=Refused (https://
> www.cdc.gov/brfss/annual_data/1993/pdf/layout93.pdf)
. *hlthpln1 (2011-2019): 1=Yes, 2=No, 7=Don't know/not sure, 9=Refused (https://
> www.cdc.gov/brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. 
. 
. *Medicare (Do you have Medicare?):
. *medicare (1996-1997): 1=Yes, 2=No, 7=Don't know/not sure, 9=Refused, BLANK=Sk
> ipped since answer to hlthplan=2,7,9 (https://www.cdc.gov/brfss/annual_data/19
> 96/files/CODEBK96.TXT)
. *medicar2 (1998-2000): 1=Yes, 2=No, 7=Don't know/not sure, 9=Refused, BLANK=Sk
> ipped since answer to hlthplan=2,7,9 (https://www.cdc.gov/brfss/annual_data/19
> 98/pdf/Codebook_98.pdf)
. 
. 
. *type of healthcare plan 1 (What type of health care coverage do you use to pa
> y for most of your medical care? Is it coverage through:):
. *typcovr1 (1996-2000): 1=Your employer, 2=Someone's employer, 3=A plan that yo
> u or someone else buys on your own, 4=Medicare, 5=Medicaid or medical assistan
> ce, 6=Military, CHAMPUS, or VA, 7=Indian Health Service, 8=Some other source, 
> 77=Don't know/not sure, 88=None, 99=Refused, BLANK=Skipped since answer to hlt
> hplan=2,7,9 (https://www.cdc.gov/brfss/annual_data/1996/files/CODEBK96.TXT)
. 
. 
. *type of healthcare plan 2 (There are some types of coverage you may not have 
> considered. Please tell me if you have any of the following: (Only persons HLT
> HPLAN=2)):
. *typcovr2 (1996-2000): 1=Your employer, 2=Someone's employer, 3=A plan that yo
> u or someone else buys on your own, 4=Medicare, 5=Medicaid or medical assistan
> ce, 6=Military, CHAMPUS, or VA, 7=Indian Health Service, 8=Some other source, 
> 77=Don't know/not sure, 88=None, 99=Refused, BLANK=Skipped since answer to hlt
> hplan=2,7,9 (https://www.cdc.gov/brfss/annual_data/1996/files/CODEBK96.TXT)
. 
. 
. 
. 
. *height:
. *htf (height in feet) (1993-2000): 2-6=Number of feet, 7=7 feet or Don't know/
> not sure, 9=Refused (https://www.cdc.gov/brfss/annual_data/1994/pdf/layout94.p
> df)
. *htm (height in meters) (2001-2002): 999=Don't know/refused/missing (https://w
> ww.cdc.gov/brfss/annual_data/2002/pdf/codebook_02.pdf)
. *htm2 (height in meters) (2003): 999=Don't know/refused/missing (https://www.c
> dc.gov/brfss/annual_data/2003/pdf/Codebook_03.pdf)
. *htm3 (height in meters) (2004-2010): 999=Don't know/refused/missing (https://
> www.cdc.gov/brfss/annual_data/2004/pdf/Codebook_04.pdf)
. *htm4 (height in meters) (2011-2019) (https://www.cdc.gov/brfss/annual_data/20
> 11/pdf/CODEBOOK11_LLCP.pdf)
. *hti (height in inches) (1993-2000): 77=Don't know/not sure, 99=Refused (https
> ://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *htin (height in inches) (2001-2002): 99=Don't know/refused/missing (https://w
> ww.cdc.gov/brfss/annual_data/2002/pdf/codebook_02.pdf)
. *htin2 (height in inches) (2003): 999=Don't know/refused/missing (https://www.
> cdc.gov/brfss/annual_data/2003/pdf/Codebook_03.pdf)
. *htin3 (height in inches) (2004-2010): 999=Don't know/refused/missing (https:/
> /www.cdc.gov/brfss/annual_data/2004/pdf/Codebook_04.pdf)
. *htin4 (height in inches) (2011-2019) (https://www.cdc.gov/brfss/annual_data/2
> 011/pdf/CODEBOOK11_LLCP.pdf)
. *height (height in feet and inches, 3-digit number) (1993-2003): 777=Don't kno
> w/not sure, 999=Refused (https://www.cdc.gov/brfss/annual_data/2001/pdf/codebo
> ok_01.pdf)
. *height2 (height in feet and inches or in meters and centimeters, 3-digit numb
> er for feet and inches (<777), 4-digit number for meters and centimeters) (200
> 4): 777=Don't know/not sure, 999=Refused, 7777=Don't know/not sure, 9999=Refus
> ed, BLANK=Missing (https://www.cdc.gov/brfss/annual_data/2004/pdf/Codebook_04.
> pdf)
. *height3 (height in feet and inches or in meters and centimeters, 3-digit numb
> er for feet and inches, 4-digit number for meters and centimeters) (2005-2019)
> : 7777=Don't know/not sure, 9999=Refused, BLANK=Not asked/missing (https://www
> .cdc.gov/brfss/annual_data/2005/pdf/Codebook_05.pdf)
. 
. 
. *weight:
. *weight (weight in pounds) (1993-2003): 777=Don't know/Not sure, 999=Refused (
> https://www.cdc.gov/brfss/annual_data/1993/pdf/layout93.pdf)
. *weight2 (weight in pounds or kilograms) (2004-2019): 3-digit number for weigh
> t in pounds, 4-digit number for weight in kilograms, 777=Don't know/not sure, 
> 7777=Don't know/not sure, 9999=Refused (https://www.cdc.gov/brfss/annual_data/
> 2004/pdf/Codebook_04.pdf)
. 
. *education:
. *educa (1993-2019): 1=Never attended school/kindergarten only, 2=Elementary, 3
> =Some high school, 4=High school graduate, 5=Some college/technical school, 6=
> College graduate or more, 9=Refused (https://www.cdc.gov/brfss/annual_data/199
> 3/pdf/layout93.pdf)
. 
. 
. *income:
. *income (1993): 1=less than 10K, 2=10K to less than 15K, 3=15K to less than 20
> K, 4=20K to less than 25K, 5= 25K to less than 35K, 6=35K to 50K, 7=Over 50K, 
> 8=Don't know/not sure, 9=Refused (https://www.cdc.gov/brfss/annual_data/1993/p
> df/layout93.pdf)
. *income (1994): 1=less than 10K, 2=10K to less than 15K, 3=15K to less than 20
> K, 4=20K to less than 25K, 5= 25K to less than 35K, 6=35K to less than 50K, 7=
> 50K to 75K, 8=Over 75K, 77=Don't know/not sure, 99=Refused (https://www.cdc.go
> v/brfss/annual_data/1994/pdf/layout94.pdf)
. *income95 (1995): 1=less than 10K, 2=10K to 14999, 3=15K to 19999, 4=20K to 24
> 999, 5= 25K to 34999, 6=35K to 49999, 7=50K to 74999, 8=Over 75K, 77=Don't kno
> w/not sure, 99=Refused (https://www.cdc.gov/brfss/annual_data/1995/pdf/layout9
> 5.pdf)
. *income2 (1996-2019): 1=less than 10K, 2=10K to 14999, 3=15K to 19999, 4=20K t
> o 24999, 5= 25K to 34999, 6=35K to 49999, 7=50K to 74999, 8=Over 75K, 77=Don't
>  know/not sure, 99=Refused (https://www.cdc.gov/brfss/annual_data/1996/files/C
> ODEBK96.TXT)
. 
. 
. *County:
. *ctycode (1993-2010): county code in numeric form
. *ctycode1 (2011-2012): county code in numeric form
. 
. 
. *The following state-years are missing (https://www.cdc.gov/brfss/annual_data/
> all_years/states_data.htm):
. *Wyoming (FIPS: 56): 1993 (This is not documented)
. *Rhode Island (FIPS: 44): 1994 (The documentation said that Rhode Island is mi
> ssing in 1993, but it is wrong)
. *Washington DC (FIPS: 11): 1995
. *Hawaii (FIPS: 15): 2004
. *New Jersey (FIPS: 34): 2019
. 
. 
. 
. 
. 
. keep if _age80>=18 //make sure the minimum age is 18
(0 observations deleted)
r; t=0.10 4:50:23

. 
. 
. *Neighborhood
. local new "neighsafe" //this variable was only asked in a small subsample in B
> RFSS (about 88000 respondents answered)
r; t=0.00 4:50:23

. local old "howsafe1"
r; t=0.00 4:50:23

. gen `new'=0 if `old'==4
(449,461 missing values generated)
r; t=0.06 4:50:23

. replace `new'=1 if `old'==3
(2,945 real changes made)
r; t=0.04 4:50:23

. replace `new'=2 if `old'==2
(46,232 real changes made)
r; t=0.06 4:50:23

. replace `new'=3 if `old'==1
(37,703 real changes made)
r; t=0.06 4:50:23

. replace `new'=.a if `old'==7 | `old'==9 //mark the missing responses for later
>  imputation
(734 real changes made, 734 to missing)
r; t=0.06 4:50:23

. label var `new' "Neighborhood safe from crime"
r; t=0.00 4:50:23

. label define `new' 0"ExtremelyUnsafe" 1"Unsafe" 2"Safe" 3"ExtremelySafe"
r; t=0.00 4:50:23

. numlabel `new', mask(#) add
r; t=2.17 4:50:26

. label value `new' `new'
r; t=0.01 4:50:26

. note `new': Original: `old' | `tag'
r; t=0.01 4:50:26

. 
. 
. *Health
. local new "srh"
r; t=0.00 4:50:26

. local old "genhlth"
r; t=0.00 4:50:26

. gen `new'=0 if `old'==5
(425,699 missing values generated)
r; t=0.07 4:50:26

. replace `new'=1 if `old'==4
(62,213 real changes made)
r; t=0.05 4:50:26

. replace `new'=2 if `old'==3
(142,502 real changes made)
r; t=0.05 4:50:26

. replace `new'=3 if `old'==2
(145,479 real changes made)
r; t=0.06 4:50:26

. replace `new'=4 if `old'==1
(74,356 real changes made)
r; t=0.04 4:50:26

. label var `new' "Self-rated health"
r; t=0.00 4:50:26

. label define `new' 0"Poor" 1"Fair" 2"Good" 3"VeryGood" 4"Excellent"
r; t=0.00 4:50:26

. numlabel `new', mask(#) add
r; t=1.96 4:50:28

. label value `new' `new'
r; t=0.01 4:50:28

. note `new': Original: `old' | `tag'
r; t=0.00 4:50:28

. 
. 
. local new "badphyhlth"
r; t=0.00 4:50:28

. local old "physhlth"
r; t=0.00 4:50:28

. gen `new'=`old' if `old'<77
(285,442 missing values generated)
r; t=0.08 4:50:28

. replace `new'=0 if `old'==88
(276,111 real changes made)
r; t=0.07 4:50:28

. label var `new' "Number of days in last month with not good physical health"
r; t=0.00 4:50:28

. note `new': Original: `old' | `tag'
r; t=0.00 4:50:28

. 
. 
. local new "badmenhlth"
r; t=0.00 4:50:28

. local old "menthlth"
r; t=0.00 4:50:28

. gen `new'=`old' if `old'<77
(307,337 missing values generated)
r; t=0.08 4:50:28

. replace `new'=0 if `old'==88
(300,134 real changes made)
r; t=0.07 4:50:28

. label var `new' "Number of days in last month with not good mental health"
r; t=0.00 4:50:28

. note `new': Original: `old' | `tag'
r; t=0.00 4:50:28

. 
. 
. local new "actpoorhlth"
r; t=0.00 4:50:28

. local old "poorhlth"
r; t=0.00 4:50:28

. gen `new'=`old' if `old'<77
(347,096 missing values generated)
r; t=0.07 4:50:28

. replace `new'=0 if `old'==88
(129,598 real changes made)
r; t=0.05 4:50:28

. label var `new' "Number of days in last month keeping R from usual activities 
> due to poor physical/mental health"
note: label truncated to 80 characters
r; t=0.01 4:50:28

. note `new': Original: `old' | `tag'
r; t=0.00 4:50:28

. 
. 
. local new "asthmadiag"
r; t=0.00 4:50:28

. local old "asthma3"
r; t=0.00 4:50:28

. gen `new'=0 if `old'==2
(63,874 missing values generated)
r; t=0.08 4:50:28

. replace `new'=1 if `old'==1
(62,411 real changes made)
r; t=0.04 4:50:28

. label var `new' "Ever told you have asthma"
r; t=0.00 4:50:28

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:50:28

. numlabel `new', mask(#) add
r; t=1.96 4:50:30

. label value `new' `new'
r; t=0.00 4:50:30

. note `new': Original: `old' | `tag'
r; t=0.00 4:50:30

. 
. 
. local new "cholesteroldiag"
r; t=0.00 4:50:30

. local old "toldhi2"
r; t=0.00 4:50:30

. gen `new'=0 if `old'==2
(190,588 missing values generated)
r; t=0.06 4:50:30

. replace `new'=1 if `old'==1
(158,724 real changes made)
r; t=0.05 4:50:30

. label var `new' "Ever told you have high cholesterol"
r; t=0.00 4:50:30

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:50:30

. numlabel `new', mask(#) add
r; t=2.14 4:50:33

. label value `new' `new'
r; t=0.01 4:50:33

. note `new': Original: `old' | `tag'
r; t=0.00 4:50:33

. 
. 
. local new "heartattackdiag"
r; t=0.00 4:50:33

. local old "cvdinfr4"
r; t=0.00 4:50:33

. gen `new'=0 if `old'==2
(28,370 missing values generated)
r; t=0.09 4:50:33

. replace `new'=1 if `old'==1
(26,004 real changes made)
r; t=0.05 4:50:33

. label var `new' "Ever told you have heart attack"
r; t=0.00 4:50:33

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:50:33

. numlabel `new', mask(#) add
r; t=2.03 4:50:35

. label value `new' `new'
r; t=0.01 4:50:35

. note `new': Original: `old' | `tag'
r; t=0.00 4:50:35

. 
. 
. local new "heartdiseasediag"
r; t=0.00 4:50:35

. local old "cvdcrhd4"
r; t=0.00 4:50:35

. gen `new'=0 if `old'==2
(29,296 missing values generated)
r; t=0.08 4:50:35

. replace `new'=1 if `old'==1
(25,389 real changes made)
r; t=0.04 4:50:35

. label var `new' "Ever told you have heart disease"
r; t=0.00 4:50:35

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:50:35

. numlabel `new', mask(#) add
r; t=2.23 4:50:37

. label value `new' `new'
r; t=0.01 4:50:37

. note `new': Original: `old' | `tag'
r; t=0.00 4:50:37

. 
. 
. local new "strokediag"
r; t=0.00 4:50:37

. local old "cvdstrk3"
r; t=0.00 4:50:37

. gen `new'=0 if `old'==2
(20,306 missing values generated)
r; t=0.08 4:50:37

. replace `new'=1 if `old'==1
(18,956 real changes made)
r; t=0.04 4:50:37

. label var `new' "Ever told you have stroke"
r; t=0.00 4:50:37

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:50:37

. numlabel `new', mask(#) add
r; t=2.31 4:50:40

. label value `new' `new'
r; t=0.01 4:50:40

. note `new': Original: `old' | `tag'
r; t=0.00 4:50:40

. 
. 
. local new "diabetesdiag"
r; t=0.00 4:50:40

. local old "diabete3"
r; t=0.00 4:50:40

. gen `new'=0 if `old'>=3 & `old'<=4
(64,520 missing values generated)
r; t=0.09 4:50:40

. replace `new'=1 if `old'==1
(60,440 real changes made)
r; t=0.04 4:50:40

. label var `new' "Ever told you have diabetes"
r; t=0.00 4:50:40

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:50:40

. numlabel `new', mask(#) add
r; t=2.12 4:50:42

. label value `new' `new'
r; t=0.00 4:50:42

. note `new': Original: `old' | `tag'
r; t=0.00 4:50:42

. 
. 
. local new "highbloodpressurediag"
r; t=0.00 4:50:42

. local old "bphigh4"
r; t=0.00 4:50:42

. gen `new'=0 if `old'>=3 & `old'<=4
(185,820 missing values generated)
r; t=0.09 4:50:42

. replace `new'=1 if `old'==1
(181,098 real changes made)
r; t=0.06 4:50:42

. label var `new' "Ever told you have high blood pressure"
r; t=0.00 4:50:42

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:50:42

. numlabel `new', mask(#) add
r; t=2.38 4:50:44

. label value `new' `new'
r; t=0.01 4:50:44

. note `new': Original: `old' | `tag'
r; t=0.00 4:50:44

. 
. 
. local new "actlim"
r; t=0.00 4:50:44

. local old "poorhlth"
r; t=0.00 4:50:44

. gen `new'=0 if `old'<14 | `old'==88 | physhlth==88 | menthlth==88
(27,088 missing values generated)
r; t=0.10 4:50:44

. replace `new'=1 if `old'>=14 & `old'<77 //14 days cutoff from (Dwyer-Lindgren 
> et al. 2017)
(40,629 real changes made)
r; t=0.05 4:50:45

. label var `new' "Frequent activity limitation"
r; t=0.00 4:50:45

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:50:45

. numlabel `new', mask(#) add
r; t=1.95 4:50:46

. label value `new' `new'
r; t=0.00 4:50:46

. note `new': Original: `old' | `tag'
r; t=0.00 4:50:46

. 
. 
. local new "walkdiff"
r; t=0.00 4:50:46

. local old "diffwalk"
r; t=0.00 4:50:46

. gen `new'=2-`old' if `old'<7
(15,550 missing values generated)
r; t=0.09 4:50:47

. label var `new' "Difficulty walking or climbing stairs"
r; t=0.00 4:50:47

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:50:47

. numlabel `new', mask(#) add
r; t=2.75 4:50:49

. label value `new' `new'
r; t=0.01 4:50:49

. note `new': Original: `old' | `tag'
r; t=0.00 4:50:49

. 
. 
. local new "dressdiff"
r; t=0.00 4:50:49

. local old "diffdres"
r; t=0.00 4:50:49

. gen `new'=2-`old' if `old'<7
(15,105 missing values generated)
r; t=0.11 4:50:49

. label var `new' "Difficulty dressing or bathing"
r; t=0.00 4:50:49

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:50:49

. numlabel `new', mask(#) add
r; t=2.89 4:50:52

. label value `new' `new'
r; t=0.00 4:50:52

. note `new': Original: `old' | `tag'
r; t=0.00 4:50:52

. 
. 
. local new "erranddiffalone"
r; t=0.00 4:50:52

. local old "diffalon"
r; t=0.00 4:50:52

. gen `new'=2-`old' if `old'<7
(16,360 missing values generated)
r; t=0.09 4:50:52

. label var `new' "Difficulty doing errands alone (e.g., shopping, visit doctor)
> "
r; t=0.00 4:50:52

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:50:52

. numlabel `new', mask(#) add
r; t=5.78 4:50:58

. label value `new' `new'
r; t=0.01 4:50:58

. note `new': Original: `old' | `tag'
r; t=0.00 4:50:58

. 
. 
. local new "funclimit"
r; t=0.00 4:50:58

. local old1 "actlim"
r; t=0.00 4:50:58

. local old2 "walkdiff"
r; t=0.00 4:50:58

. local old3 "dressdiff"
r; t=0.00 4:50:58

. local old4 "erranddiffalone"
r; t=0.00 4:50:58

. gen `new'=`old1' +`old2' + `old3' + `old4'
(20,384 missing values generated)
r; t=0.05 4:50:58

. label var `new' "Functional limitation index"
r; t=0.00 4:50:58

. note `new': Original: `old1' `old2' `old3' `old4' | `tag'
r; t=0.00 4:50:58

. 
. 
. 
. 
. 
. 
. *Psychosocial
. local new "stress_days"
r; t=0.00 4:50:58

. local old "sdhstres"
r; t=0.00 4:50:58

. gen `new'=`old'-1 if `old'<=5
(362,847 missing values generated)
r; t=0.07 4:50:58

. label var `new' "Felt stress in last 30 days"
r; t=0.00 4:50:58

. label define `new' 0"NoneoftheTime" 1"ALittleoftheTime" 2"SomeoftheTime" 3"Mos
> toftheTime" 4"AlloftheTime"
r; t=0.00 4:50:58

. numlabel `new', mask(#_) add
r; t=3.16 4:51:01

. label value `new' `new'
r; t=0.01 4:51:02

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:02

. 
. 
. 
. 
. 
. *Health behaviors
. local new "bodycheck"
r; t=0.00 4:51:02

. local old "checkup1"
r; t=0.00 4:51:02

. gen `new'=5-`old' if `old'<=4
(9,774 missing values generated)
r; t=0.09 4:51:02

. replace `new'=0 if `old'==8
(3,988 real changes made)
r; t=0.03 4:51:02

. label var `new' "Last time did body check up"
r; t=0.00 4:51:02

. label define `new' 0"Never" 1"5orMoreYearsAgo" 2"2-5YearsAgo" 3"1-2YearsAgo" 4
> "1-12MonthsAgo"
r; t=0.00 4:51:02

. numlabel `new', mask(#_) add
r; t=2.62 4:51:04

. label value `new' `new'
r; t=0.01 4:51:04

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:04

. 
. 
. local new "alcoholnum"
r; t=0.00 4:51:04

. local old "alcday5"
r; t=0.00 4:51:04

. gen `new'=(`old'-100)/7 if `old'>=100 & `old'<=107
(390,996 missing values generated)
r; t=0.08 4:51:04

. replace `new'=(`old'-200)/30 if `old'>=201 & `old'<=230
(162,113 real changes made)
r; t=0.06 4:51:04

. replace `new'=0 if `old'==888
(203,183 real changes made)
r; t=0.06 4:51:04

. label var `new' "Average number of days of alcohol drinking in last month"
r; t=0.00 4:51:04

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:04

. 
. 
. local new "bingedrink"
r; t=0.00 4:51:04

. local old "_rfbing5"
r; t=0.00 4:51:04

. gen `new'=`old'-1 if `old'<9
(29,611 missing values generated)
r; t=0.09 4:51:05

. label var `new' "Binge drinking in last 30 days"
r; t=0.00 4:51:05

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:51:05

. numlabel `new', mask(#) add
r; t=3.24 4:51:08

. label value `new' `new'
r; t=0.01 4:51:08

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:08

. 
. 
. local new "heavydrink"
r; t=0.00 4:51:08

. local old "_rfdrhv5"
r; t=0.00 4:51:08

. gen `new'=`old'-1 if `old'<9
(30,180 missing values generated)
r; t=0.09 4:51:08

. label var `new' "Heavy drinking in last 30 days"
r; t=0.00 4:51:08

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:51:08

. numlabel `new', mask(#) add
r; t=3.00 4:51:11

. label value `new' `new'
r; t=0.00 4:51:11

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:11

. 
. 
. 
. local new "smokeever"
r; t=0.00 4:51:11

. local old "smoke100"
r; t=0.00 4:51:11

. gen `new'=0 if `old'==2
(203,912 missing values generated)
r; t=0.07 4:51:11

. replace `new'=1 if `old'==1
(185,596 real changes made)
r; t=0.05 4:51:11

. label var `new' "Ever smoke at least 100 cigarettes in life"
r; t=0.00 4:51:11

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:51:11

. numlabel `new', mask(#) add
r; t=2.44 4:51:13

. label value `new' `new'
r; t=0.00 4:51:13

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:13

. 
. 
. local new "smoking"
r; t=0.00 4:51:13

. local old "smokday2"
r; t=0.00 4:51:13

. gen `new'=0 if smokeever==0
(203,912 missing values generated)
r; t=0.06 4:51:14

. replace `new'=1 if `old'==3 & smokeever==1
(121,722 real changes made)
r; t=0.07 4:51:14

. replace `new'=2 if `old'==2
(18,849 real changes made)
r; t=0.05 4:51:14

. replace `new'=3 if `old'==1
(44,617 real changes made)
r; t=0.04 4:51:14

. label var `new' "How often smoke cigarettes"
r; t=0.00 4:51:14

. label define `new' 0"Never" 1"NoSmokingReg" 2"SomeDays" 3"Everyday"
r; t=0.00 4:51:14

. numlabel `new', mask(#) add
r; t=1.97 4:51:16

. label value `new' `new'
r; t=0.01 4:51:16

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:16

. 
. 
. local new "smokingsim"
r; t=0.00 4:51:16

. local old "smoking"
r; t=0.00 4:51:16

. gen `new'=0 if `old'==0
(203,912 missing values generated)
r; t=0.07 4:51:16

. replace `new'=1 if `old'==1
(121,722 real changes made)
r; t=0.05 4:51:16

. replace `new'=2 if `old'==2 | `old'==3
(63,466 real changes made)
r; t=0.05 4:51:16

. label var `new' "How often smoke cigarettes"
r; t=0.00 4:51:16

. label define `new' 0"Never" 1"NoSmokingReg" 2"SomeorEveryDay"
r; t=0.00 4:51:16

. numlabel `new', mask(#) add
r; t=2.32 4:51:18

. label value `new' `new'
r; t=0.00 4:51:18

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:18

. 
. 
. local new "vegserv" //this variable includes dark green vegetables, french fri
> es, potato, and other vegetables intake
r; t=0.00 4:51:18

. local old "_vegesu1"
r; t=0.00 4:51:18

. gen `new'=`old'/100 if _vegete1==0 //exclude those who reported 24 servings or
>  more per day (too high, according to official codebook)
(48,220 missing values generated)
r; t=0.08 4:51:18

. label var `new' "Vegetables servings per day"
r; t=0.00 4:51:18

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:18

. 
. 
. local new "veg1perday"
r; t=0.00 4:51:18

. local old "vegserv"
r; t=0.00 4:51:18

. gen `new'=0 if `old'<1
(382,246 missing values generated)
r; t=0.04 4:51:18

. replace `new'=1 if `old'>=1 & !mi(`old')
(334,026 real changes made)
r; t=0.05 4:51:18

. label var `new' "1 or more vegetables servings per day"
r; t=0.00 4:51:18

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:51:18

. numlabel `new', mask(#) add
r; t=2.37 4:51:21

. label value `new' `new'
r; t=0.01 4:51:21

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:21

. 
. 
. local new "greenvegserv"
r; t=0.00 4:51:21

. local old "grenda1_"
r; t=0.00 4:51:21

. gen `new'=`old'/100 if !mi(`old') & `old'<1000 //exclude those who reported 10
>  servings or more per day (too high)
(33,717 missing values generated)
r; t=0.11 4:51:21

. label var `new' "Dark green vegetables servings per day"
r; t=0.00 4:51:21

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:21

. 
. 
. local new "greenveg1perday"
r; t=0.00 4:51:21

. local old "greenvegserv"
r; t=0.00 4:51:21

. gen `new'=0 if `old'<1
(141,595 missing values generated)
r; t=0.07 4:51:21

. replace `new'=1 if `old'>=1 & !mi(`old')
(107,878 real changes made)
r; t=0.05 4:51:21

. label var `new' "1 or more green vegetables servings per day"
r; t=0.00 4:51:21

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:51:21

. numlabel `new', mask(#) add
r; t=2.23 4:51:23

. label value `new' `new'
r; t=0.00 4:51:23

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:23

. 
. 
. local new "friesserv"
r; t=0.00 4:51:23

. local old "frnchda_"
r; t=0.00 4:51:23

. gen `new'=`old'/100 if !mi(`old') & `old'<1000 //exclude those who reported 10
>  servings or more per day (too high)
(33,524 missing values generated)
r; t=0.09 4:51:23

. label var `new' "French fries servings per day"
r; t=0.00 4:51:23

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:23

. 
. 
. local new "fries1perday"
r; t=0.00 4:51:23

. local old "friesserv"
r; t=0.00 4:51:23

. gen `new'=0 if `old'<1
(48,353 missing values generated)
r; t=0.08 4:51:23

. replace `new'=1 if `old'>=1 & !mi(`old')
(14,829 real changes made)
r; t=0.05 4:51:23

. label var `new' "1 or more french fries servings per day"
r; t=0.00 4:51:23

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:51:23

. numlabel `new', mask(#) add
r; t=2.39 4:51:26

. label value `new' `new'
r; t=0.00 4:51:26

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:26

. 
. 
. local new "potatoserv"
r; t=0.00 4:51:26

. local old "potada1_"
r; t=0.00 4:51:26

. gen `new'=`old'/100 if !mi(`old') & `old'<1000 //exclude those who reported 10
>  servings or more per day (too high)
(36,843 missing values generated)
r; t=0.09 4:51:26

. label var `new' "Potato servings per day"
r; t=0.00 4:51:26

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:26

. 
. 
. local new "potato1perday"
r; t=0.00 4:51:26

. local old "potatoserv"
r; t=0.00 4:51:26

. gen `new'=0 if `old'<1
(55,359 missing values generated)
r; t=0.06 4:51:26

. replace `new'=1 if `old'>=1 & !mi(`old')
(18,516 real changes made)
r; t=0.03 4:51:26

. label var `new' "1 or more potato servings per day"
r; t=0.00 4:51:26

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:51:26

. numlabel `new', mask(#) add
r; t=2.58 4:51:29

. label value `new' `new'
r; t=0.01 4:51:29

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:29

. 
. 
. local new "othvegserv"
r; t=0.00 4:51:29

. local old "vegeda2_"
r; t=0.00 4:51:29

. gen `new'=`old'/100 if !mi(`old') & `old'<1000 //exclude those who reported 10
>  servings or more per day (too high)
(38,015 missing values generated)
r; t=0.11 4:51:29

. label var `new' "Other vegetables servings per day"
r; t=0.00 4:51:29

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:29

. 
. 
. local new "otherveg1perday"
r; t=0.00 4:51:29

. local old "othvegserv"
r; t=0.00 4:51:29

. gen `new'=0 if `old'<1
(255,559 missing values generated)
r; t=0.06 4:51:29

. replace `new'=1 if `old'>=1 & !mi(`old')
(217,544 real changes made)
r; t=0.05 4:51:29

. label var `new' "1 or more other vegetables servings per day"
r; t=0.00 4:51:29

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:51:29

. numlabel `new', mask(#) add
r; t=2.55 4:51:31

. label value `new' `new'
r; t=0.01 4:51:31

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:31

. 
. 
. local new "totalfruitserv" //this variable includes fruit juice and fruit inta
> ke
r; t=0.00 4:51:31

. local old "_frutsu1"
r; t=0.00 4:51:31

. gen `new'=`old'/100 if _vegete1==0 //exclude those who reported 17 servings or
>  more per day (too high, according to official codebook)
(51,856 missing values generated)
r; t=0.13 4:51:31

. label var `new' "Total fruit servings per day"
r; t=0.00 4:51:31

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:31

. 
. 
. local new "totalfruit1perday"
r; t=0.00 4:51:31

. local old "totalfruitserv"
r; t=0.00 4:51:31

. gen `new'=0 if `old'<1
(311,814 missing values generated)
r; t=0.08 4:51:32

. replace `new'=1 if `old'>=1 & !mi(`old')
(259,958 real changes made)
r; t=0.06 4:51:32

. label var `new' "1 or more total fruit servings per day"
r; t=0.00 4:51:32

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:51:32

. numlabel `new', mask(#) add
r; t=4.31 4:51:36

. label value `new' `new'
r; t=0.01 4:51:36

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:36

. 
. 
. local new "fruitjuiceserv"
r; t=0.00 4:51:36

. local old "ftjuda2_"
r; t=0.00 4:51:36

. gen `new'=`old'/100 if !mi(`old') & `old'<8000 //exclude those who reported 8 
> servings or more per day (too high)
(33,251 missing values generated)
r; t=0.11 4:51:36

. label var `new' "Fruit juice servings per day"
r; t=0.00 4:51:36

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:36

. 
. 
. local new "fruitjuice1perday"
r; t=0.00 4:51:36

. local old "fruitjuiceserv"
r; t=0.00 4:51:36

. gen `new'=0 if `old'<1
(108,095 missing values generated)
r; t=0.08 4:51:36

. replace `new'=1 if `old'>=1 & !mi(`old')
(74,844 real changes made)
r; t=0.04 4:51:36

. label var `new' "1 or more fruit juice servings per day"
r; t=0.00 4:51:36

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:51:36

. numlabel `new', mask(#) add
r; t=4.81 4:51:41

. label value `new' `new'
r; t=0.02 4:51:41

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:41

. 
. 
. local new "fruitserv"
r; t=0.00 4:51:41

. local old "frutda2_"
r; t=0.00 4:51:41

. gen `new'=`old'/100 if !mi(`old') & `old'<8000 //exclude those who reported 8 
> servings or more per day (too high)
(33,639 missing values generated)
r; t=0.09 4:51:41

. label var `new' "Fruit servings per day"
r; t=0.00 4:51:41

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:41

. 
. 
. local new "fruit1perday"
r; t=0.00 4:51:41

. local old "fruitserv"
r; t=0.00 4:51:41

. gen `new'=0 if `old'<1
(272,607 missing values generated)
r; t=0.04 4:51:41

. replace `new'=1 if `old'>=1 & !mi(`old')
(238,968 real changes made)
r; t=0.04 4:51:41

. label var `new' "1 or more fruit servings per day"
r; t=0.00 4:51:41

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:51:41

. numlabel `new', mask(#) add
r; t=3.64 4:51:45

. label value `new' `new'
r; t=0.01 4:51:45

. note `new': Original: `old' | `tag'
r; t=0.01 4:51:45

. 
. 
. local new "soda_freq" //this variable was only asked in a small subsample in B
> RFSS (about 53000 respondents answered)
r; t=0.00 4:51:45

. local old "ssbsugr2"
r; t=0.00 4:51:45

. gen `new'=`old'-100 if `old'>100 & `old'<200
(443,250 missing values generated)
r; t=0.04 4:51:45

. replace `new'=(`old'-200)/7 if `old'>200 & `old'<300
(8,340 real changes made)
r; t=0.02 4:51:45

. replace `new'=(`old'-300)/30 if `old'>300 & `old'<400
(13,177 real changes made)
r; t=0.03 4:51:45

. replace `new'=0 if `old'==888
(25,102 real changes made)
r; t=0.02 4:51:45

. replace `new'=. if `new'>30 & !mi(`new') //exclude those who reported 31 or mo
> re times per day (too high)
(11 real changes made, 11 to missing)
r; t=0.03 4:51:45

. label var `new' "Soda with sugar (times per day in last month)"
r; t=0.00 4:51:45

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:45

. 
. 
. local new "soda1perday"
r; t=0.00 4:51:45

. local old "soda_freq"
r; t=0.00 4:51:45

. gen `new'=0 if `old'<1
(404,322 missing values generated)
r; t=0.02 4:51:45

. replace `new'=1 if `old'>=1 & !mi(`old')
(7,680 real changes made)
r; t=0.03 4:51:45

. label var `new' "1 or more soda drinking (times per day) in last month"
r; t=0.00 4:51:45

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:51:45

. numlabel `new', mask(#) add
r; t=4.99 4:51:50

. label value `new' `new'
r; t=0.02 4:51:50

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:50

. 
. 
. local new "sweetbev_freq" //this variable was only asked in a small subsample 
> in BRFSS (about 53000 respondents answered)
r; t=0.00 4:51:50

. local old "ssbfrut3"
r; t=0.00 4:51:50

. gen `new'=`old'-100 if `old'>100 & `old'<200
(444,755 missing values generated)
r; t=0.07 4:51:50

. replace `new'=(`old'-200)/7 if `old'>200 & `old'<300
(7,292 real changes made)
r; t=0.06 4:51:50

. replace `new'=(`old'-300)/30 if `old'>300 & `old'<400
(10,940 real changes made)
r; t=0.04 4:51:50

. replace `new'=0 if `old'==888
(29,672 real changes made)
r; t=0.05 4:51:50

. replace `new'=. if `new'>30 & !mi(`new') //exclude those who reported 31 or mo
> re times per day (too high)
(5 real changes made, 5 to missing)
r; t=0.05 4:51:50

. label var `new' "Sugar sweetened beverages (times per day in last month)"
r; t=0.00 4:51:50

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:50

. 
. 
. local new "sweetbev1perday"
r; t=0.00 4:51:50

. local old "sweetbev_freq"
r; t=0.00 4:51:50

. gen `new'=0 if `old'<1
(403,014 missing values generated)
r; t=0.06 4:51:50

. replace `new'=1 if `old'>=1 & !mi(`old')
(6,158 real changes made)
r; t=0.02 4:51:50

. label var `new' "1 or more sweetened beverages drinking (times per day) in las
> t month"
r; t=0.00 4:51:50

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:51:50

. numlabel `new', mask(#) add
r; t=4.31 4:51:55

. label value `new' `new'
r; t=0.01 4:51:55

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:55

. 
. 
. 
. local new "anyflushot"
r; t=0.00 4:51:55

. local old "flushot6"
r; t=0.00 4:51:55

. gen `new'=0 if `old'==2
(230,783 missing values generated)
r; t=0.07 4:51:55

. replace `new'=1 if `old'==1
(189,998 real changes made)
r; t=0.05 4:51:55

. label var `new' "Flu shot last year"
r; t=0.00 4:51:55

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:51:55

. numlabel `new', mask(#) add
r; t=3.64 4:51:58

. label value `new' `new'
r; t=0.00 4:51:58

. note `new': Original: `old' | `tag'
r; t=0.00 4:51:58

. 
. 
. local new "seatbeltusage"
r; t=0.00 4:51:58

. local old "seatbelt"
r; t=0.00 4:51:58

. gen `new'=5-`old' if `old'>=1 & `old'<=5
(39,594 missing values generated)
r; t=0.09 4:51:59

. label var `new' "Seat belt usage"
r; t=0.00 4:51:59

. label define `new' 0"Never" 1"Seldom" 2"Sometimes" 3"Nearly always" 4"Always"
r; t=0.00 4:51:59

. numlabel `new', mask(#) add
r; t=2.40 4:52:01

. label value `new' `new'
r; t=0.01 4:52:01

. note `new': Original: `old' | `tag'
r; t=0.00 4:52:01

. 
. 
. local new "weightinkg"
r; t=0.00 4:52:01

. local old "weight2"
r; t=0.00 4:52:01

. gen `new'=`old'*0.45359237 if `old'<777
(31,035 missing values generated)
r; t=0.09 4:52:01

. replace `new'=`old'-9000 if `old'>7777 & `old'<9999
(1,170 real changes made)
r; t=0.05 4:52:01

. label var `new' "Weight (kg)"
r; t=0.00 4:52:01

. note `new': Original: `old' | `tag'
r; t=0.00 4:52:01

. 
. 
. local new "heightinmeter"
r; t=0.00 4:52:01

. local old "height3"
r; t=0.00 4:52:01

. gen `new'=real(substr(string(`old'), 1, 1))/3.2808+real(substr(string(`old'), 
> 2, 2))/39.37 if `old'<777
(18,040 missing values generated)
r; t=0.61 4:52:02

. replace `new'=(`old'-9000)/100 if `old'>7777 & `old'<9230
(1,601 real changes made)
r; t=0.06 4:52:02

. label var `new' "Height (m)"
r; t=0.00 4:52:02

. note `new': Original: `old' | `tag'
r; t=0.00 4:52:02

. 
. 
. local new "bmi"
r; t=0.00 4:52:02

. local old "_bmi5"
r; t=0.00 4:52:02

. gen `new'=`old'/100 if !mi(`old')
(36,446 missing values generated)
r; t=0.10 4:52:02

. label var `new' "Body mass index"
r; t=0.00 4:52:02

. note `new': Original: `old' | `tag'
r; t=0.00 4:52:02

. 
. 
. local new "bmicat"
r; t=0.00 4:52:02

. local old "_bmi5cat"
r; t=0.00 4:52:02

. gen `new'=`old'-1 if `old'<=4
(36,446 missing values generated)
r; t=0.11 4:52:02

. label var `new' "BMI category"
r; t=0.01 4:52:02

. label define `new' 0"Underweight" 1"Normal" 2"Overweight" 3"Obese"
r; t=0.00 4:52:02

. numlabel `new', mask(#) add
r; t=2.80 4:52:05

. label value `new' `new'
r; t=0.00 4:52:05

. note `new': Original: `old' | `tag'
r; t=0.00 4:52:05

. 
. 
. local new "hivrisk"
r; t=0.00 4:52:05

. local old "hivrisk5"
r; t=0.00 4:52:05

. gen `new'=0 if `old'==2
(60,176 missing values generated)
r; t=0.09 4:52:05

. replace `new'=1 if `old'==1
(16,030 real changes made)
r; t=0.05 4:52:05

. label var `new' "High HIV risk behaviors last year"
r; t=0.00 4:52:05

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:52:05

. numlabel `new', mask(#) add
r; t=2.26 4:52:07

. label value `new' `new'
r; t=0.01 4:52:07

. note `new': Original: `old' | `tag'
r; t=0.00 4:52:07

. 
. 
. local new "cantgetmorefood"
r; t=0.00 4:52:07

. local old "sdhfood"
r; t=0.00 4:52:07

. gen `new'=3-`old' if `old'<7
(362,650 missing values generated)
r; t=0.09 4:52:07

. label var `new' "Food didn't last and no money to get more in last 12 months"
r; t=0.00 4:52:07

. label define `new' 0"NeverTrue" 1"SometimesTrue" 2"OftenTrue"
r; t=0.00 4:52:07

. numlabel `new', mask(#) add
r; t=2.86 4:52:10

. label value `new' `new'
r; t=0.01 4:52:10

. note `new': Original: `old' | `tag'
r; t=0.00 4:52:10

. 
. 
. local new "balancedmeal"
r; t=0.00 4:52:10

. local old "sdhmeals"
r; t=0.00 4:52:10

. gen `new'=3-`old' if `old'<7
(362,679 missing values generated)
r; t=0.09 4:52:10

. label var `new' "Can't afford balanced meals in last 12 months"
r; t=0.00 4:52:10

. label define `new' 0"NeverTrue" 1"SometimesTrue" 2"OftenTrue"
r; t=0.00 4:52:10

. numlabel `new', mask(#) add
r; t=3.01 4:52:13

. label value `new' `new'
r; t=0.01 4:52:13

. note `new': Original: `old' | `tag'
r; t=0.00 4:52:13

. 
. 
. 
. 
. 
. *Physical activity
. local new "exercise"
r; t=0.00 4:52:13

. local old "exerany2"
r; t=0.00 4:52:13

. gen `new'=0 if `old'==2
(335,233 missing values generated)
r; t=0.10 4:52:13

. replace `new'=1 if `old'==1
(301,030 real changes made)
r; t=0.09 4:52:13

. label var `new' "Any exercise (except regular job) last month"
r; t=0.00 4:52:13

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:52:13

. numlabel `new', mask(#) add
r; t=2.84 4:52:16

. label value `new' `new'
r; t=0.01 4:52:16

. note `new': Original: `old' | `tag'
r; t=0.00 4:52:16

. 
. 
. local new "exercise1type"
r; t=0.00 4:52:16

. local old "exract11"
r; t=0.00 4:52:16

. gen `new'=`old' if `old'<77
(166,532 missing values generated)
r; t=0.11 4:52:16

. label var `new' "Type of physical activity"
r; t=0.00 4:52:16

. note `new': Original: `old' | `tag'
r; t=0.00 4:52:16

. 
. 
. local new "exercise1freq"
r; t=0.00 4:52:16

. local old "exeroft1"
r; t=0.00 4:52:16

. gen `new'=`old' if `old'>=101 & `old'<=199
(237,968 missing values generated)
r; t=0.11 4:52:17

. replace `new'=`old'/4 if `old'>=201 & `old'<=299
(83,742 real changes made)
r; t=0.07 4:52:17

. label var `new' "Frequency of exercise (times per week)"
r; t=0.00 4:52:17

. note `new': Original: `old' | `tag'
r; t=0.00 4:52:17

. 
. 
. local new "exercise1min"
r; t=0.00 4:52:17

. local old "exerhmm1"
r; t=0.00 4:52:17

. gen `new'=`old' if `old'<100
(288,897 missing values generated)
r; t=0.10 4:52:17

. replace `new'=int(`old'/100)*60 + mod(`old',100) if `old'>=100 & `old'<=959 & 
> `old'!=777 // int(`old'/100) extracts the hundreds digit and mod(`old',100) ex
> tracts the remainder of the number after division by 100
(131,492 real changes made)
r; t=0.07 4:52:17

. label var `new' "Usual exercise duration (minutes)"
r; t=0.00 4:52:17

. note `new': Original: `old' | `tag'
r; t=0.00 4:52:17

. 
. 
. local new "exercise2type"
r; t=0.00 4:52:17

. local old "exract21"
r; t=0.00 4:52:17

. gen `new'=`old' if `old'<77
(272,757 missing values generated)
r; t=0.09 4:52:17

. label var `new' "Type of physical activity"
r; t=0.00 4:52:17

. note `new': Original: `old' | `tag'
r; t=0.00 4:52:17

. 
. 
. local new "exercise2freq"
r; t=0.00 4:52:17

. local old "exeroft2"
r; t=0.00 4:52:17

. gen `new'=`old' if `old'>=101 & `old'<=199
(320,116 missing values generated)
r; t=0.09 4:52:17

. replace `new'=`old'/4 if `old'>=201 & `old'<=299
(63,331 real changes made)
r; t=0.06 4:52:17

. label var `new' "Frequency of exercise (times per week)"
r; t=0.00 4:52:17

. note `new': Original: `old' | `tag'
r; t=0.00 4:52:17

. 
. 
. local new "exercise2min"
r; t=0.00 4:52:17

. local old "exerhmm2"
r; t=0.00 4:52:17

. gen `new'=`old' if `old'<100
(351,033 missing values generated)
r; t=0.09 4:52:17

. replace `new'=int(`old'/100)*60 + mod(`old',100) if `old'>=100 & `old'<=959 & 
> `old'!=777 // int(`old'/100) extracts the hundreds digit and mod(`old',100) ex
> tracts the remainder of the number after division by 100
(92,381 real changes made)
r; t=0.08 4:52:17

. label var `new' "Usual exercise duration (minutes)"
r; t=0.00 4:52:17

. note `new': Original: `old' | `tag'
r; t=0.00 4:52:17

. 
. 
. local new "muscleexercise"
r; t=0.00 4:52:17

. local old "strength"
r; t=0.00 4:52:17

. gen `new'=`old' if `old'>=101 & `old'<=199
(340,372 missing values generated)
r; t=0.09 4:52:17

. replace `new'=`old'/4 if `old'>=201 & `old'<=299
(49,183 real changes made)
r; t=0.06 4:52:17

. label var `new' "Frequency of muscle-strengthening exercise (times per week)"
r; t=0.00 4:52:17

. note `new': Original: `old' | `tag'
r; t=0.01 4:52:17

. 
. 
. local new "exe_total_min"
r; t=0.00 4:52:17

. local old1 "pa1min_"
r; t=0.00 4:52:17

. local old2 "exercise"
r; t=0.00 4:52:17

. gen `new'=`old1' if !mi(`old1')
(156,652 missing values generated)
r; t=0.10 4:52:17

. replace `new'=0 if `old2'==0
(114,783 real changes made)
r; t=0.05 4:52:17

. label var `new' "Minutes of the two reported exercises per week (last month)"
r; t=0.00 4:52:17

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 4:52:17

. 
. 
. local new "exe1_intensity"
r; t=0.00 4:52:17

. local old1 "actin11_"
r; t=0.00 4:52:17

. local old2 "exercise"
r; t=0.00 4:52:17

. gen `new'=`old1'+1
(154,229 missing values generated)
r; t=0.08 4:52:18

. replace `new'=0 if `old2'==0
(114,783 real changes made)
r; t=0.06 4:52:18

. label var `new' "Intensity of 1st reported type of exercise in last month"
r; t=0.00 4:52:18

. label define `new' 0"NoExercise" 1"LightExercise" 2"ModerateExercise" 3"Vigoro
> usExercise"
r; t=0.00 4:52:18

. numlabel `new', mask(#) add
r; t=2.33 4:52:20

. label value `new' `new'
r; t=0.01 4:52:20

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 4:52:20

. 
. 
. local new "exe2_intensity"
r; t=0.00 4:52:20

. local old1 "actin21_"
r; t=0.00 4:52:20

. local old2 "exercise"
r; t=0.00 4:52:20

. gen `new'=`old1'+1 //Note that respondents who reported only the 1st but not 2
> nd exercise are coded as missing
(159,168 missing values generated)
r; t=0.08 4:52:20

. replace `new'=0 if `old2'==0
(114,783 real changes made)
r; t=0.06 4:52:20

. label var `new' "Intensity of 2nd reported type of exercise in last month"
r; t=0.00 4:52:20

. label define `new' 0"NoExercise" 1"LightExercise" 2"ModerateExercise" 3"Vigoro
> usExercise"
r; t=0.00 4:52:20

. numlabel `new', mask(#) add
r; t=2.94 4:52:23

. label value `new' `new'
r; t=0.01 4:52:23

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 4:52:23

. 
. 
. local new "exe_intensity"
r; t=0.00 4:52:23

. local old1 "exe1_intensity"
r; t=0.00 4:52:23

. local old2 "exe2_intensity"
r; t=0.00 4:52:23

. gen `new'=0 if `old1'==0 & `old2'==0
(335,233 missing values generated)
r; t=0.08 4:52:23

. replace `new'=1 if `old1'==1 & mi(`old2')
(168 real changes made)
r; t=0.06 4:52:23

. replace `new'=2 if `old1'==2 & mi(`old2')
(3,291 real changes made)
r; t=0.05 4:52:23

. replace `new'=3 if `old1'==3 & mi(`old2')
(1,481 real changes made)
r; t=0.05 4:52:23

. replace `new'=4 if `old1'==1 & `old2'==1
(2,911 real changes made)
r; t=0.06 4:52:23

. replace `new'=5 if (`old1'==1 & `old2'==2) | (`old1'==2 & `old2'==1)
(95,795 real changes made)
r; t=0.07 4:52:23

. replace `new'=6 if (`old1'==1 & `old2'==3) | (`old1'==3 & `old2'==1)
(38,162 real changes made)
r; t=0.07 4:52:23

. replace `new'=7 if `old1'==2 & `old2'==2
(54,948 real changes made)
r; t=0.06 4:52:24

. replace `new'=8 if (`old1'==2 & `old2'==3) | (`old1'==3 & `old2'==2)
(64,346 real changes made)
r; t=0.07 4:52:24

. replace `new'=9 if `old1'==3 & `old2'==3
(34,685 real changes made)
r; t=0.04 4:52:24

. label var `new' "Intensity of two reported types of exercise in last month"
r; t=0.00 4:52:24

. label define `new' 0"NoExercise" 1"OneLightEx" 2"OneModEx" 3"OneVigEx" 4"TwoLi
> ghtEx" ///
> 5"Light&ModEx" 6"Light&VigEx" 7"TwoModEx" 8"Mod&VigEx" 9"TwoVigEx"
r; t=0.00 4:52:24

. numlabel `new', mask(#) add
r; t=2.71 4:52:26

. label value `new' `new'
r; t=0.01 4:52:26

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 4:52:26

. 
. 
. local new "exe_intensity_sim"
r; t=0.00 4:52:26

. local old "exe_intensity"
r; t=0.00 4:52:26

. gen `new'=0 if `old'==0
(335,233 missing values generated)
r; t=0.06 4:52:26

. replace `new'=1 if `old'>=1 & `old'<=4
(7,851 real changes made)
r; t=0.05 4:52:26

. replace `new'=2 if `old'==5
(95,795 real changes made)
r; t=0.05 4:52:27

. replace `new'=3 if `old'==6
(38,162 real changes made)
r; t=0.04 4:52:27

. replace `new'=4 if `old'==7
(54,948 real changes made)
r; t=0.05 4:52:27

. replace `new'=5 if `old'==8
(64,346 real changes made)
r; t=0.04 4:52:27

. replace `new'=6 if `old'==9
(34,685 real changes made)
r; t=0.05 4:52:27

. label var `new' "Intensity of two reported types of exercise in last month"
r; t=0.00 4:52:27

. label define `new' 0"NoExercise" 1"OneExOrTwoLight" 2"Light&ModEx" 3"Light&Vig
> Ex" 4"TwoModEx" 5"Mod&VigEx" 6"TwoVigEx"
r; t=0.00 4:52:27

. numlabel `new', mask(#) add
r; t=2.86 4:52:30

. label value `new' `new'
r; t=0.01 4:52:30

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 4:52:30

. 
. 
. local new "exe_intensity_simplest"
r; t=0.00 4:52:30

. local old "exe_intensity_sim"
r; t=0.00 4:52:30

. gen `new'=0 if `old'==0
(335,233 missing values generated)
r; t=0.07 4:52:30

. replace `new'=1 if `old'>=1 & `old'<=4
(196,756 real changes made)
r; t=0.06 4:52:30

. replace `new'=2 if `old'==5
(64,346 real changes made)
r; t=0.05 4:52:30

. replace `new'=3 if `old'==6
(34,685 real changes made)
r; t=0.04 4:52:30

. label var `new' "Intensity of two reported types of exercise in last month"
r; t=0.00 4:52:30

. label define `new' 0"NoExercise" 1"TwoModExOrBelow" 2"Mod&VigEx" 3"TwoVigEx"
r; t=0.00 4:52:30

. numlabel `new', mask(#) add
r; t=2.78 4:52:33

. label value `new' `new'
r; t=0.01 4:52:33

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 4:52:33

. 
. 
. 
. local new "exe1_freq"
r; t=0.00 4:52:33

. local old1 "pafreq1_"
r; t=0.00 4:52:33

. local old2 "exercise"
r; t=0.00 4:52:33

. gen `new'=`old1'/1000 if !mi(`old1')
(154,226 missing values generated)
r; t=0.11 4:52:33

. replace `new'=0 if `old2'==0
(114,783 real changes made)
r; t=0.05 4:52:33

. replace `new'=. if `old1'==99000
(26 real changes made, 26 to missing)
r; t=0.06 4:52:33

. label var `new' "Frequency of 1st reported type of exercise per week (last mon
> th)"
r; t=0.00 4:52:33

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 4:52:33

. 
. 
. local new "exe2_freq"
r; t=0.00 4:52:33

. local old1 "pafreq2_"
r; t=0.00 4:52:33

. local old2 "exercise"
r; t=0.00 4:52:33

. local old3 "exe2_intensity"
r; t=0.00 4:52:33

. gen `new'=`old1'/1000 if !mi(`old1')
(256,785 missing values generated)
r; t=0.10 4:52:33

. replace `new'=0 if `old2'==0 | mi(`old3') //Respondents who reported the 1st b
> ut not the 2nd exercise are coded as 0
(159,168 real changes made)
r; t=0.09 4:52:33

. replace `new'=. if `old1'==99000
(29 real changes made, 29 to missing)
r; t=0.03 4:52:33

. label var `new' "Frequency of 1st reported type of exercise per week (last mon
> th)"
r; t=0.00 4:52:33

. note `new': Original: `old1' `old2' `old3' | `tag'
r; t=0.00 4:52:33

. 
. 
. local new "exe1_min_per_week"
r; t=0.00 4:52:33

. local old1 "_minac11"
r; t=0.00 4:52:33

. local old2 "exercise"
r; t=0.00 4:52:33

. gen `new'=`old1' if !mi(`old1')
(159,318 missing values generated)
r; t=0.11 4:52:33

. replace `new'=4000 if `new'>=4000 & !mi(`new') //Top code the responses to be 
> 4000 minutes per week.
(197 real changes made)
r; t=0.05 4:52:33

. replace `new'=0 if `old2'==0
(114,783 real changes made)
r; t=0.06 4:52:33

. label var `new' "Minutes of 1st reported type of exercise per week (last month
> )"
r; t=0.00 4:52:33

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 4:52:33

. 
. 
. xtile exe1_min_quartile=exe1_min_per_week, nq(4)
r; t=4.28 4:52:38

. xtile exe1_min_quintile=exe1_min_per_week, nq(5)
r; t=4.46 4:52:42

. xtile exe1_min_sextile=exe1_min_per_week, nq(6)
r; t=4.46 4:52:47

. xtile exe1_min_dectile=exe1_min_per_week, nq(10)
r; t=4.61 4:52:51

. 
. 
. local new "exe2_min_per_week"
r; t=0.00 4:52:51

. local old1 "_minac21"
r; t=0.00 4:52:51

. local old2 "exercise"
r; t=0.00 4:52:51

. local old3 "exe2_intensity"
r; t=0.00 4:52:51

. gen `new'=`old1' if !mi(`old1')
(161,257 missing values generated)
r; t=0.11 4:52:51

. replace `new'=4000 if `new'>=4000 & !mi(`new') //Top code the responses to be 
> 4000 minutes per week.
(156 real changes made)
r; t=0.04 4:52:51

. replace `new'=0 if `old2'==0 | mi(`old3') //Respondents who reported the 1st b
> ut not the 2nd exercise are coded as 0
(157,579 real changes made)
r; t=0.08 4:52:51

. label var `new' "Minutes of 2nd reported type of exercise per week (last month
> )"
r; t=0.00 4:52:51

. note `new': Original: `old1' `old2' `old3' | `tag'
r; t=0.00 4:52:51

. 
. xtile exe2_min_quartile=exe2_min_per_week, nq(4)
r; t=4.07 4:52:55

. xtile exe2_min_quintile=exe2_min_per_week, nq(5)
r; t=3.76 4:52:59

. xtile exe2_min_sextile=exe2_min_per_week, nq(6)
r; t=4.46 4:53:04

. xtile exe2_min_dectile=exe2_min_per_week, nq(10)
r; t=4.09 4:53:08

. 
. 
. local new "strength_exe_freq"
r; t=0.00 4:53:08

. local old "strfreq_"
r; t=0.00 4:53:08

. gen `new'=`old'/1000
(41,439 missing values generated)
r; t=0.06 4:53:08

. replace `new'=. if `old'==99000
(15 real changes made, 15 to missing)
r; t=0.04 4:53:08

. label var `new' "Frequency of muscle strengthening exercise (times per week, l
> ast month)"
r; t=0.00 4:53:08

. note `new': Original: `old' | `tag'
r; t=0.00 4:53:08

. 
. xtile strength_time_tertile=strength_exe_freq, nq(3) //only tertile can be cal
> culated since the variable's distribution is very sparse.
r; t=3.51 4:53:11

. 
. 
. 
. 
. local new "exe_vigeq_min_per_week"
r; t=0.00 4:53:11

. local old1 "pa1min_"
r; t=0.00 4:53:11

. local old2 "exercise"
r; t=0.00 4:53:11

. gen `new'=`old1' if !mi(`old1')
(156,652 missing values generated)
r; t=0.09 4:53:11

. replace `new'=0 if `old2'==0
(114,783 real changes made)
r; t=0.05 4:53:12

. label var `new' "Vigorous equivalent minutes of exercise per week (last month)
> "
r; t=0.00 4:53:12

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 4:53:12

. 
. 
. local new "exe_vig_min_per_week"
r; t=0.00 4:53:12

. local old1 "pa1vigm_"
r; t=0.00 4:53:12

. local old2 "exercise"
r; t=0.00 4:53:12

. gen `new'=`old1' if !mi(`old1')
(155,153 missing values generated)
r; t=0.10 4:53:12

. replace `new'=0 if `old2'==0
(114,783 real changes made)
r; t=0.04 4:53:12

. label var `new' "Vigorous minutes of exercise per week (last month)"
r; t=0.00 4:53:12

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 4:53:12

. 
. 
. local new "exe_active" //Note: this variable is not recommended to be used sin
> ce respondents who only reported 1 type of exercise (about 2524) were excluded
>  due to lack of data to classify their overall exercise time per week
r; t=0.00 4:53:12

. local old "_pacat1"
r; t=0.00 4:53:12

. gen `new'=4-`old' if `old'<9
(52,681 missing values generated)
r; t=0.10 4:53:12

. label var `new' "Sufficient exercise per week in last month"
r; t=0.00 4:53:12

. label define `new' 0"Inactive" 1"InsufficientlyActive" 2"Active" 3"HighlyActiv
> e"
r; t=0.00 4:53:12

. numlabel `new', mask(#) add
r; t=2.24 4:53:14

. label value `new' `new'
r; t=0.01 4:53:14

. note `new': Original: `old' Exercise per week guideline reference: https://www
> .ncbi.nlm.nih.gov/books/NBK566046/ | `tag'
r; t=0.00 4:53:14

. 
. 
. local new "exe_aerobic_advice"
r; t=0.00 4:53:14

. local old "_pa150r2"
r; t=0.00 4:53:14

. gen `new'=3-`old' if `old'<9
(50,157 missing values generated)
r; t=0.11 4:53:14

. label var `new' "Meet aerobic exercise recommendations (150+ min per week) las
> t month"
r; t=0.00 4:53:14

. label define `new' 0"NoAerobicExercise" 1"Under149MinEx" 2"150+MinEx"
r; t=0.00 4:53:14

. numlabel `new', mask(#) add
r; t=2.43 4:53:17

. label value `new' `new'
r; t=0.01 4:53:17

. note `new': Original: `old' | `tag'
r; t=0.00 4:53:17

. 
. 
. local new "exe_strength_advice"
r; t=0.00 4:53:17

. local old "_pastrng"
r; t=0.00 4:53:17

. gen `new'=2-`old' if `old'<9
(41,439 missing values generated)
r; t=0.10 4:53:17

. label var `new' "Meet muscle strengthening recommendations (at least 2 times p
> er week) last month"
r; t=0.00 4:53:17

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:53:17

. numlabel `new', mask(#) add
r; t=2.63 4:53:19

. label value `new' `new'
r; t=0.00 4:53:19

. note `new': Original: `old' | `tag'
r; t=0.00 4:53:19

. 
. 
. local new "exe_aero_strength_advice"
r; t=0.00 4:53:19

. local old "_parec1"
r; t=0.00 4:53:19

. gen `new'=4-`old' if `old'<9
(55,281 missing values generated)
r; t=0.10 4:53:19

. label var `new' "Meet areobic and muscle strengthening recommendations last mo
> nth"
r; t=0.00 4:53:19

. label define `new' 0"Neither" 1"StrengtheningOnly" 2"AerobicOnly" 3"Both"
r; t=0.00 4:53:19

. numlabel `new', mask(#) add
r; t=2.24 4:53:22

. label value `new' `new'
r; t=0.01 4:53:22

. note `new': Original: `old' | `tag'
r; t=0.01 4:53:22

. 
. 
. local new "metval1"
r; t=0.00 4:53:22

. local old1 "metvl11_"
r; t=0.00 4:53:22

. local old2 "exercise"
r; t=0.00 4:53:22

. gen `new'=`old1' if `old1'<=128
(150,553 missing values generated)
r; t=0.11 4:53:22

. replace `new'=0 if `old2'==0 //assign those who reported no regular exercise w
> ith 0 MET
(114,783 real changes made)
r; t=0.06 4:53:22

. label var `new' "Metabolic equivalents (METs) of the 1st reported exercise"
r; t=0.00 4:53:22

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 4:53:22

. 
. 
. local new "metval2"
r; t=0.00 4:53:22

. local old1 "metvl11_"
r; t=0.00 4:53:22

. local old2 "exercise"
r; t=0.00 4:53:22

. gen `new'=`old1' if `old1'<=128
(150,553 missing values generated)
r; t=0.09 4:53:22

. replace `new'=0 if `old2'==0 //assign those who reported no regular exercise w
> ith 0 MET
(114,783 real changes made)
r; t=0.05 4:53:22

. label var `new' "Metabolic equivalents (METs) of the 2nd reported exercise"
r; t=0.00 4:53:22

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 4:53:22

. 
. 
. local new "metval_avg"
r; t=0.00 4:53:22

. local old1 "metval1"
r; t=0.00 4:53:22

. local old2 "metval2"
r; t=0.00 4:53:22

. gen `new'=(`old1'+`old2')/2
(35,770 missing values generated)
r; t=0.06 4:53:22

. label var `new' "Average metabolic equivalents (METs) of the 2 reported exerci
> ses"
r; t=0.00 4:53:22

. note `new': Original: `old' | `tag'
r; t=0.00 4:53:22

. 
. 
. /*
> local new "metval_quartile"
> local old "metval_avg"
> xtile `new'=`old', nq(4)
> label var `new' "Average metabolic equivalents (METs) of the 2 reported exerci
> ses"
> label define `new' 1"1stQuartile" 2"2ndQuartile" 3"3rdQuartile" 4"4thQuartile"
> numlabel `new', mask(#) add
> label value `new' `new'
> local ivarlist `ivarlist' `new'
> note `new': Original: `old' | `tag'
> */
. 
. 
. 
. 
. *Healthcare
. local new "afforddoc"
r; t=0.00 4:53:22

. local old "medcost"
r; t=0.00 4:53:22

. gen `new'=0 if `old'==2
(48,826 missing values generated)
r; t=0.08 4:53:22

. replace `new'=1 if `old'==1
(47,528 real changes made)
r; t=0.05 4:53:22

. label var `new' "Cannot see doc due to cost in last 12 months"
r; t=0.00 4:53:22

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:53:22

. numlabel `new', mask(#) add
r; t=3.56 4:53:26

. label value `new' `new'
r; t=0.01 4:53:26

. note `new': Original: `old' | `tag'
r; t=0.00 4:53:26

. 
. 
. local new "hlthcare"
r; t=0.00 4:53:26

. local old "hlthpln1"
r; t=0.00 4:53:26

. gen `new'=0 if `old'==2
(414,273 missing values generated)
r; t=0.06 4:53:26

. replace `new'=1 if `old'==1
(412,502 real changes made)
r; t=0.08 4:53:26

. label var `new' "Any healthcare coverage (either private or public)?"
r; t=0.00 4:53:26

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:53:26

. numlabel `new', mask(#) add
r; t=2.36 4:53:28

. label value `new' `new'
r; t=0.01 4:53:28

. note `new': Original: `old' | `tag'
r; t=0.00 4:53:28

. 
. 
. local new "hlthcare1864"
r; t=0.00 4:53:28

. local old "_hcvu651"
r; t=0.00 4:53:28

. gen `new'=0 if `old'==2
(417,164 missing values generated)
r; t=0.08 4:53:28

. replace `new'=1 if `old'==1
(253,280 real changes made)
r; t=0.08 4:53:28

. label var `new' "Any healthcare coverage? (18-64 years old only)"
r; t=0.00 4:53:28

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:53:28

. numlabel `new', mask(#) add
r; t=2.76 4:53:31

. label value `new' `new'
r; t=0.01 4:53:31

. note `new': Original: `old' | `tag'
r; t=0.00 4:53:31

. 
. 
. 
. 
. 
. *Sociodemographic variables
. local new "oxygen_max"
r; t=0.00 4:53:31

. local old "maxvo2_"
r; t=0.00 4:53:31

. gen `new'=`old'/100 if `old'<99900
(6,298 missing values generated)
r; t=0.10 4:53:31

. label var `new' "Estimated Maximum Oxygen Consumption (mL/kg/min)"
r; t=0.00 4:53:31

. note `new': Original: `old' | `tag'
r; t=0.00 4:53:31

. 
. 
. local new "yearsold"
r; t=0.00 4:53:31

. local old "_age80"
r; t=0.00 4:53:31

. gen `new'=`old' if `old'<=80
r; t=0.10 4:53:31

. label var `new' "Age"
r; t=0.00 4:53:31

. note `new': Original: `old' | `tag'
r; t=0.00 4:53:31

. 
. 
. 
. local new "agegroup"
r; t=0.00 4:53:31

. local old "yearsold"
r; t=0.00 4:53:31

. gen `new'=0 if `old'>=18 & `old'<=20
(439,438 missing values generated)
r; t=0.06 4:53:31

. replace `new'=1 if `old'>=21 & `old'<=25
(20,080 real changes made)
r; t=0.05 4:53:32

. replace `new'=2 if `old'>=26 & `old'<=30
(23,110 real changes made)
r; t=0.05 4:53:32

. replace `new'=3 if `old'>=31 & `old'<=35
(25,195 real changes made)
r; t=0.06 4:53:32

. replace `new'=4 if `old'>=36 & `old'<=40
(26,826 real changes made)
r; t=0.04 4:53:32

. replace `new'=5 if `old'>=41 & `old'<=45
(25,722 real changes made)
r; t=0.05 4:53:32

. replace `new'=6 if `old'>=46 & `old'<=50
(33,381 real changes made)
r; t=0.07 4:53:32

. replace `new'=7 if `old'>=51 & `old'<=55
(39,583 real changes made)
r; t=0.05 4:53:32

. replace `new'=8 if `old'>=56 & `old'<=60
(47,292 real changes made)
r; t=0.05 4:53:32

. replace `new'=9 if `old'>=61 & `old'<=65
(51,959 real changes made)
r; t=0.06 4:53:32

. replace `new'=10 if `old'>=66 & `old'<=70
(50,830 real changes made)
r; t=0.05 4:53:32

. replace `new'=11 if `old'>=71 & `old'<=75
(37,592 real changes made)
r; t=0.04 4:53:32

. replace `new'=12 if `old'>=76 & `old'<=80
(57,868 real changes made)
r; t=0.05 4:53:32

. label var `new' "Age Group"
r; t=0.00 4:53:32

. label define `new' 0"18-20" 1"21-25" 2"26-30" 3"31-35" 4"36-40" 5"41-45" 6"46-
> 50" 7"51-55" 8"56-60" 9"61-65" 10"66-70" 11"71-75" 12"76-80"
r; t=0.00 4:53:32

. numlabel `new', mask(#_) add
r; t=3.49 4:53:36

. label value `new' `new'
r; t=0.01 4:53:36

. note `new': Original: `old' | `tag'
r; t=0.00 4:53:36

. 
. 
. local new "agegroup_sim"
r; t=0.00 4:53:36

. local old "agegroup"
r; t=0.00 4:53:36

. gen `new'=0 if `old'>=0 & `old'<=4
(344,227 missing values generated)
r; t=0.08 4:53:36

. replace `new'=1 if `old'>=5 & `old'<=9
(197,937 real changes made)
r; t=0.07 4:53:36

. replace `new'=2 if `old'>=10 & `old'<=12
(146,290 real changes made)
r; t=0.07 4:53:36

. label var `new' "Age Group"
r; t=0.00 4:53:36

. label define `new' 0"18-40" 1"41-65" 2"66-80"
r; t=0.00 4:53:36

. numlabel `new', mask(#_) add
r; t=2.99 4:53:39

. label value `new' `new'
r; t=0.01 4:53:39

. note `new': Original: `old' | `tag'
r; t=0.00 4:53:39

. 
. 
. local new "educ"
r; t=0.00 4:53:39

. local old "educa"
r; t=0.00 4:53:39

. gen `new'=0 if `old'>=1 & `old'<=3
(417,329 missing values generated)
r; t=0.08 4:53:39

. replace `new'=1 if `old'==4
(122,577 real changes made)
r; t=0.07 4:53:39

. replace `new'=2 if `old'==5
(124,655 real changes made)
r; t=0.06 4:53:39

. replace `new'=3 if `old'==6
(168,390 real changes made)
r; t=0.07 4:53:39

. label var `new' "Education"
r; t=0.00 4:53:39

. label define `new' 0"BelowHighSch" 1"HighSch" 2"SomeCollege" 3"CollegeorAbove"
r; t=0.00 4:53:39

. numlabel `new', mask(#) add
r; t=3.11 4:53:42

. label value `new' `new'
r; t=0.00 4:53:42

. note `new': Original: `old' | `tag'
r; t=0.00 4:53:42

. 
. 
. local new "edu"
r; t=0.00 4:53:42

. local old "educa"
r; t=0.00 4:53:42

. gen `new'=0 if `old'>=1 & `old'<=4
(294,752 missing values generated)
r; t=0.11 4:53:42

. replace `new'=1 if `old'==5
(124,655 real changes made)
r; t=0.07 4:53:42

. replace `new'=2 if `old'==6
(168,390 real changes made)
r; t=0.07 4:53:42

. label var `new' "Education"
r; t=0.00 4:53:42

. label define `new' 0"HighSchorBelow" 1"SomeCollege" 2"CollegeorAbove"
r; t=0.00 4:53:42

. numlabel `new', mask(#) add
r; t=2.63 4:53:45

. label value `new' `new'
r; t=0.01 4:53:45

. note `new': Original: `old' | `tag'
r; t=0.00 4:53:45

. 
. 
. local new "employstatus_full"
r; t=0.00 4:53:45

. local old "employ1"
r; t=0.00 4:53:45

. gen `new'=0 if `old'>=1 & `old'<=2
(226,331 missing values generated)
r; t=0.08 4:53:45

. replace `new'=1 if `old'>=3 & `old'<=4
(19,714 real changes made)
r; t=0.05 4:53:45

. replace `new'=2 if `old'==5
(24,376 real changes made)
r; t=0.05 4:53:45

. replace `new'=3 if `old'==6
(12,181 real changes made)
r; t=0.05 4:53:45

. replace `new'=4 if `old'==7
(133,648 real changes made)
r; t=0.06 4:53:45

. replace `new'=5 if `old'==8
(32,706 real changes made)
r; t=0.05 4:53:45

. label var `new' "Employment Status"
r; t=0.00 4:53:45

. label define `new' 0"Employed" 1"Unemployed" 2"Homemaker" 3"Student" 4"Retired
> " 5"UnabletoWork"
r; t=0.00 4:53:45

. numlabel `new', mask(#) add
r; t=2.60 4:53:48

. label value `new' `new'
r; t=0.01 4:53:48

. note `new': Original: `old' | `tag'
r; t=0.00 4:53:48

. 
. 
. 
. local new "employstatus"
r; t=0.00 4:53:48

. local old "employ1"
r; t=0.00 4:53:48

. gen `new'=0 if `old'>=1 & `old'<=2
(226,331 missing values generated)
r; t=0.10 4:53:48

. replace `new'=1 if `old'>=3 & `old'<=4
(19,714 real changes made)
r; t=0.05 4:53:48

. replace `new'=2 if `old'>=5 & `old'<=8
(202,911 real changes made)
r; t=0.07 4:53:48

. label var `new' "Employment Status"
r; t=0.00 4:53:48

. label define `new' 0"Employed" 1"Unemployed" 2"Other"
r; t=0.00 4:53:48

. numlabel `new', mask(#) add
r; t=2.86 4:53:51

. label value `new' `new'
r; t=0.02 4:53:51

. note `new': Original: `old' | `tag'
r; t=0.00 4:53:51

. 
. 
. local new "male"
r; t=0.00 4:53:51

. local old "sex"
r; t=0.00 4:53:51

. gen `new'=0 if `old'==2
(199,009 missing values generated)
r; t=0.10 4:53:51

. replace `new'=1 if `old'==1
(198,725 real changes made)
r; t=0.08 4:53:51

. label var `new' "Sex"
r; t=0.00 4:53:51

. label define `new' 0"Female" 1"Male"
r; t=0.00 4:53:51

. numlabel `new', mask(#) add
r; t=2.68 4:53:54

. label value `new' `new'
r; t=0.01 4:53:54

. note `new': Original: `old' | `tag'
r; t=0.00 4:53:54

. 
. 
. local new "hispanic"
r; t=0.00 4:53:54

. local old "_hispanc"
r; t=0.00 4:53:54

. gen `new'=2-`old' if `old'<9
(4,497 missing values generated)
r; t=0.10 4:53:54

. label var `new' "Hispanic"
r; t=0.00 4:53:54

. label define `new' 0"Non-Hispanic" 1"Hispanic"
r; t=0.00 4:53:54

. numlabel `new', mask(#) add
r; t=2.81 4:53:57

. label value `new' `new'
r; t=0.01 4:53:57

. note `new': Original: `old' | `tag'
r; t=0.00 4:53:57

. 
. 
. local new "prace"
r; t=0.00 4:53:57

. local old "_prace1"
r; t=0.00 4:53:57

. gen `new'=0 if `old'==1
(86,218 missing values generated)
r; t=0.09 4:53:57

. replace `new'=1 if `old'==2
(38,825 real changes made)
r; t=0.05 4:53:57

. replace `new'=2 if `old'==3
(10,715 real changes made)
r; t=0.04 4:53:57

. replace `new'=3 if `old'==4
(10,951 real changes made)
r; t=0.05 4:53:57

. replace `new'=4 if `old'==5
(3,127 real changes made)
r; t=0.07 4:53:57

. replace `new'=5 if `old'>=6 & `old'<=8
(11,463 real changes made)
r; t=0.06 4:53:57

. label var `new' "Preferred Racial Group"
r; t=0.00 4:53:57

. label define `new' 0"White" 1"Black" 2"NativeAm" 3"Asian" 4"NativeHawaiianPacI
> slander" 5"Other"
r; t=0.00 4:53:57

. numlabel `new', mask(#) add
r; t=2.72 4:54:00

. label value `new' `new'
r; t=0.02 4:54:00

. note `new': Original: `old' | `tag'
r; t=0.00 4:54:00

. 
. 
. local new "praceethnicgpf" //Note that those who didn't respond to Hispanic qu
> estion are missing in this variable
r; t=0.00 4:54:00

. local old1 "prace"
r; t=0.00 4:54:00

. local old2 "hispanic"
r; t=0.00 4:54:00

. gen `new'=0 if `old1'==0 & `old2'==0
(108,668 missing values generated)
r; t=0.08 4:54:00

. replace `new'=1 if `old1'==1 & `old2'==0
(36,851 real changes made)
r; t=0.06 4:54:00

. replace `new'=2 if `old1'==1 & `old2'==1
(1,652 real changes made)
r; t=0.05 4:54:00

. replace `new'=3 if `old1'==0 & `old2'==1
(20,925 real changes made)
r; t=0.05 4:54:00

. replace `new'=4 if `old1'==2
(10,715 real changes made)
r; t=0.03 4:54:00

. replace `new'=5 if `old1'==3
(10,951 real changes made)
r; t=0.05 4:54:00

. replace `new'=6 if `old1'==4 & `old2'==0
(2,597 real changes made)
r; t=0.05 4:54:00

. replace `new'=7 if `old1'==4 & `old2'==1
(501 real changes made)
r; t=0.05 4:54:01

. replace `new'=8 if `old1'==5
(11,463 real changes made)
r; t=0.05 4:54:01

. label var `new' "Racial/ethnic Group"
r; t=0.00 4:54:01

. label define `new' 0"Non-HispanicWhite" 1"Non-HispanicBlack" 2"HispanicBlack" 
> 3"HispanicWhite" 4"NativeAm" ///
> 5"Asian" 6"Non-HispanicNHPI" 7"HispanicNHPI" 8"Other"
r; t=0.00 4:54:01

. numlabel `new', mask(#) add
r; t=2.74 4:54:03

. label value `new' `new'
r; t=0.11 4:54:03

. note `new': Original: `old' | `tag'
r; t=0.00 4:54:03

. 
. 
. local new "praceethnicgp" //Note that those who didn't respond to Hispanic que
> stion are missing in this variable
r; t=0.00 4:54:03

. local vold "praceethnicgpf"
r; t=0.00 4:54:03

. gen `new'=0 if `vold'==0
(108,668 missing values generated)
r; t=0.08 4:54:04

. replace `new'=1 if `vold'==1
(36,851 real changes made)
r; t=0.04 4:54:04

. replace `new'=2 if `vold'==2
(1,652 real changes made)
r; t=0.05 4:54:04

. replace `new'=3 if `vold'==3
(20,925 real changes made)
r; t=0.03 4:54:04

. replace `new'=4 if `vold'==6
(2,597 real changes made)
r; t=0.04 4:54:04

. replace `new'=5 if `vold'==7
(501 real changes made)
r; t=0.05 4:54:04

. replace `new'=6 if `vold'==4 | `vold'==5 | `vold'==8
(33,129 real changes made)
r; t=0.04 4:54:04

. label var `new' "Racial/ethnic Group"
r; t=0.00 4:54:04

. label define `new' 0"WhiteNon-Hispanic" 1"Non-HispanicBlack" 2"HispanicBlack" 
> ///
> 3"HispanicWhite" 4"Non-HispanicNHPI" 5"HispanicNHPI" 6"Other"
r; t=0.00 4:54:04

. numlabel `new', mask(#) add
r; t=3.26 4:54:07

. label value `new' `new'
r; t=0.00 4:54:07

. note `new': Refer to `vold' | `tag'
r; t=0.00 4:54:07

. 
. 
. local new "praceethnicgp_sim" //Note that I force those who responded to race 
> question but not Hispanic question to be either Black, NHPI, or other
r; t=0.00 4:54:07

. local vold1 "praceethnicgpf"
r; t=0.00 4:54:07

. local vold2 "prace"
r; t=0.00 4:54:07

. gen `new'=0 if `vold1'==0
(108,668 missing values generated)
r; t=0.09 4:54:07

. replace `new'=1 if `vold1'==1 | `vold1'==2 | `vold2'==1
(38,825 real changes made)
r; t=0.06 4:54:07

. replace `new'=2 if `vold1'==3
(20,925 real changes made)
r; t=0.05 4:54:07

. replace `new'=3 if `vold1'==6 | `vold1'==7 | `vold2'==4
(3,127 real changes made)
r; t=0.05 4:54:07

. replace `new'=4 if `vold1'==4 | `vold1'==5 | `vold1'==8 | `vold2'==2 | `vold2'
> ==3 | `vold2'==5
(33,129 real changes made)
r; t=0.07 4:54:07

. label var `new' "Racial/ethnic Group"
r; t=0.00 4:54:07

. label define `new' 0"WhiteNon-Hispanic" 1"Black" 2"HispanicWhite" 3"NHPI" 4"Ot
> her"
r; t=0.00 4:54:07

. numlabel `new', mask(#) add
r; t=3.24 4:54:11

. label value `new' `new'
r; t=0.01 4:54:11

. note `new': Refer to `vold' | `tag'
r; t=0.00 4:54:11

. 
. 
. 
. local new "mrace"
r; t=0.00 4:54:11

. local old "_mrace1"
r; t=0.00 4:54:11

. gen `new'=0 if `old'==1
(90,754 missing values generated)
r; t=0.10 4:54:11

. replace `new'=1 if `old'==2
(37,655 real changes made)
r; t=0.06 4:54:11

. replace `new'=2 if `old'==3
(9,823 real changes made)
r; t=0.05 4:54:11

. replace `new'=3 if `old'==4
(10,166 real changes made)
r; t=0.05 4:54:11

. replace `new'=4 if `old'==5
(1,916 real changes made)
r; t=0.05 4:54:11

. replace `new'=5 if `old'==6
(9,760 real changes made)
r; t=0.05 4:54:11

. replace `new'=6 if `old'==7
(10,297 real changes made)
r; t=0.05 4:54:11

. label var `new' "Multiracial Racial Categorization"
r; t=0.00 4:54:11

. label define `new' 0"White" 1"Black" 2"NativeAm" 3"Asian" 4"NativeHawaiianPacI
> slander" 5"Other" 6"Multiracial"
r; t=0.00 4:54:11

. numlabel `new', mask(#) add
r; t=2.71 4:54:14

. label value `new' `new'
r; t=0.01 4:54:14

. note `new': Original: `old' | `tag'
r; t=0.00 4:54:14

. 
. 
. local new "mraceethnicgpf" //Note that those who didn't respond to Hispanic qu
> estion are missing in this variable
r; t=0.00 4:54:14

. local old1 "mrace"
r; t=0.00 4:54:14

. local old2 "hispanic"
r; t=0.00 4:54:14

. gen `new'=0 if `old1'==0 & `old2'==0
(112,850 missing values generated)
r; t=0.08 4:54:14

. replace `new'=1 if `old1'==1 & `old2'==0
(35,765 real changes made)
r; t=0.05 4:54:14

. replace `new'=2 if `old1'==1 & `old2'==1
(1,577 real changes made)
r; t=0.05 4:54:14

. replace `new'=3 if `old1'==0 & `old2'==1
(20,598 real changes made)
r; t=0.05 4:54:14

. replace `new'=4 if `old1'==2
(9,823 real changes made)
r; t=0.03 4:54:14

. replace `new'=5 if `old1'==3
(10,166 real changes made)
r; t=0.03 4:54:14

. replace `new'=6 if `old1'==4 & `old2'==0
(1,552 real changes made)
r; t=0.05 4:54:14

. replace `new'=7 if `old1'==4 & `old2'==1
(343 real changes made)
r; t=0.06 4:54:14

. replace `new'=8 if `old1'==5
(9,760 real changes made)
r; t=0.04 4:54:14

. label var `new' "Racial/ethnic Group"
r; t=0.00 4:54:14

. label define `new' 0"Non-HispanicWhite" 1"Non-HispanicBlack" 2"HispanicBlack" 
> 3"HispanicWhite" 4"NativeAm" ///
> 5"Asian" 6"Non-HispanicNHPI" 7"HispanicNHPI" 8"Other"
r; t=0.00 4:54:14

. numlabel `new', mask(#) add
r; t=3.24 4:54:17

. label value `new' `new'
r; t=0.01 4:54:17

. note `new': Original: `old' | `tag'
r; t=0.00 4:54:17

. 
. 
. local new "mraceethnicgp" //Note that those who didn't respond to Hispanic que
> stion are missing in this variable
r; t=0.00 4:54:17

. local vold "mraceethnicgpf"
r; t=0.00 4:54:17

. gen `new'=0 if `vold'==0
(112,850 missing values generated)
r; t=0.07 4:54:17

. replace `new'=1 if `vold'==1
(35,765 real changes made)
r; t=0.03 4:54:18

. replace `new'=2 if `vold'==2
(1,577 real changes made)
r; t=0.04 4:54:18

. replace `new'=3 if `vold'==3
(20,598 real changes made)
r; t=0.03 4:54:18

. replace `new'=4 if `vold'==6
(1,552 real changes made)
r; t=0.04 4:54:18

. replace `new'=5 if `vold'==7
(343 real changes made)
r; t=0.03 4:54:18

. replace `new'=6 if `vold'==4 | `vold'==5 | `vold'==8
(29,749 real changes made)
r; t=0.05 4:54:18

. label var `new' "Racial/ethnic Group"
r; t=0.00 4:54:18

. label define `new' 0"WhiteNon-Hispanic" 1"Non-HispanicBlack" 2"HispanicBlack" 
> ///
> 3"HispanicWhite" 4"Non-HispanicNHPI" 5"HispanicNHPI" 6"Other"
r; t=0.00 4:54:18

. numlabel `new', mask(#) add
r; t=2.51 4:54:20

. label value `new' `new'
r; t=0.00 4:54:20

. note `new': Refer to `vold' | `tag'
r; t=0.00 4:54:20

. 
. 
. local new "multiracial_mark"
r; t=0.00 4:54:20

. local old1 "_prace1"
r; t=0.00 4:54:20

. local old2 "_mrace1"
r; t=0.00 4:54:20

. gen `new'=0 if `old1'==`old2' & `old1'<77
(19,997 missing values generated)
r; t=0.08 4:54:20

. replace `new'=1 if `old1'!=`old2' & `old1'<77
(8,860 real changes made)
r; t=0.05 4:54:20

. label var `new' "Multiracial Marker"
r; t=0.00 4:54:20

. label define `new' 0"SingleRaceOrNoPreferred" 1"PreferredRaceandMultiracial"
r; t=0.00 4:54:20

. numlabel `new', mask(#) add
r; t=1.82 4:54:22

. label value `new' `new'
r; t=0.00 4:54:22

. note `new': Original: `old' | `tag'
r; t=0.00 4:54:22

. 
. 
. local new "praceethnicgp_multi" //Note that I force those who responded to rac
> e question but not Hispanic question to be either Black, NHPI, or other
r; t=0.00 4:54:22

. local vold1 "praceethnicgp_sim"
r; t=0.00 4:54:22

. local vold2 "multiracial_mark"
r; t=0.00 4:54:22

. gen `new'=0 if `vold1'==0 & `vold2'==0
(112,850 missing values generated)
r; t=0.09 4:54:22

. replace `new'=1 if `vold1'==0 & `vold2'==1
(4,182 real changes made)
r; t=0.06 4:54:22

. replace `new'=2 if `vold1'==1 & `vold2'==0
(37,655 real changes made)
r; t=0.06 4:54:22

. replace `new'=3 if `vold1'==1 & `vold2'==1
(1,170 real changes made)
r; t=0.06 4:54:22

. replace `new'=4 if `vold1'==2 & `vold2'==0
(20,598 real changes made)
r; t=0.07 4:54:22

. replace `new'=5 if `vold1'==2 & `vold2'==1
(327 real changes made)
r; t=0.06 4:54:23

. replace `new'=6 if `vold1'==3 & `vold2'==0
(1,916 real changes made)
r; t=0.05 4:54:23

. replace `new'=7 if `vold1'==3 & `vold2'==1
(1,211 real changes made)
r; t=0.05 4:54:23

. replace `new'=8 if `vold1'==4 & `vold2'==0
(31,186 real changes made)
r; t=0.06 4:54:23

. replace `new'=9 if `vold1'==4 & `vold2'==1
(1,943 real changes made)
r; t=0.06 4:54:23

. label var `new' "Racial/ethnic Group"
r; t=0.00 4:54:23

. label define `new' 0"nHWhite_Single" 1"nHwhite_Multi" 2"Black_Single" 3"Black_
> Multi" ///
> 4"HWhite_Single" 5"HWhite_Multi" 6"NHPI_Single" 7"NHPI_Multi" 8"Other_Single" 
> 9"Other_Multi"
r; t=0.00 4:54:23

. numlabel `new', mask(#) add
r; t=2.59 4:54:25

. label value `new' `new'
r; t=0.01 4:54:25

. note `new': Refer to `vold1' `vold2' | `tag'
r; t=0.00 4:54:25

. 
. 
. local new "praceethnicgp_multi_sim" //Note that I force those who responded to
>  race question but not Hispanic question to be either Black, NHPI, or other
r; t=0.00 4:54:25

. local vold "praceethnicgp_multi"
r; t=0.00 4:54:25

. gen `new'=0 if `vold'==0
(112,850 missing values generated)
r; t=0.07 4:54:25

. replace `new'=1 if `vold'==1
(4,182 real changes made)
r; t=0.04 4:54:25

. replace `new'=2 if `vold'==6
(1,916 real changes made)
r; t=0.03 4:54:26

. replace `new'=3 if `vold'==7
(1,211 real changes made)
r; t=0.04 4:54:26

. replace `new'=4 if (`vold'>=2 & `vold'<=5) | (`vold'>=8 & `vold'<=9)
(92,879 real changes made)
r; t=0.04 4:54:26

. label var `new' "Racial/ethnic Group"
r; t=0.00 4:54:26

. label define `new' 0"nHWhite_Single" 1"nHwhite_Multi" 2"NHPI_Single" 3"NHPI_Mu
> lti" 4"Other"
r; t=0.00 4:54:26

. numlabel `new', mask(#) add
r; t=2.02 4:54:28

. label value `new' `new'
r; t=0.03 4:54:28

. note `new': Refer to `vold' | `tag'
r; t=0.00 4:54:28

. 
. 
. local new "praceethnicgp_multi_sim2" //Note that I force those who responded t
> o race question but not Hispanic question to be either Black, NHPI, or other
r; t=0.00 4:54:28

. local vold "praceethnicgp_multi_sim"
r; t=0.00 4:54:28

. gen `new'=0 if `vold'==0 | `vold'==1
(108,668 missing values generated)
r; t=0.07 4:54:28

. replace `new'=1 if `vold'==2
(1,916 real changes made)
r; t=0.03 4:54:28

. replace `new'=2 if `vold'==3
(1,211 real changes made)
r; t=0.04 4:54:28

. replace `new'=3 if `vold'==4
(92,879 real changes made)
r; t=0.04 4:54:28

. label var `new' "Racial/ethnic Group"
r; t=0.00 4:54:28

. label define `new' 0"nHWhite" 1"NHPI_Single" 2"NHPI_Multi" 3"Other"
r; t=0.00 4:54:28

. numlabel `new', mask(#) add
r; t=2.10 4:54:30

. label value `new' `new'
r; t=0.00 4:54:30

. note `new': Refer to `vold' | `tag'
r; t=0.00 4:54:30

. 
. 
. local new "praceethnicgp_multi_altsim" //Note that I force those who responded
>  to race question but not Hispanic question to be either Black, NHPI, or other
r; t=0.00 4:54:30

. local vold "praceethnicgp_multi"
r; t=0.00 4:54:30

. gen `new'=0 if `vold'==0
(112,850 missing values generated)
r; t=0.07 4:54:30

. replace `new'=1 if `vold'==1
(4,182 real changes made)
r; t=0.04 4:54:30

. replace `new'=2 if `vold'==2
(37,655 real changes made)
r; t=0.03 4:54:30

. replace `new'=3 if `vold'==3
(1,170 real changes made)
r; t=0.04 4:54:30

. replace `new'=4 if `vold'==4 | `vold'==5
(20,925 real changes made)
r; t=0.04 4:54:30

. replace `new'=5 if `vold'==6
(1,916 real changes made)
r; t=0.04 4:54:30

. replace `new'=6 if `vold'==7
(1,211 real changes made)
r; t=0.04 4:54:30

. replace `new'=7 if `vold'==8
(31,186 real changes made)
r; t=0.04 4:54:30

. replace `new'=8 if `vold'==9
(1,943 real changes made)
r; t=0.05 4:54:30

. label var `new' "Racial/ethnic Group"
r; t=0.00 4:54:30

. label define `new' 0"nHWhite_Single" 1"nHwhite_Multi" 2"Black_Single" 3"Black_
> Multi" 4"HWhite" 5"NHPI_Single" 6"NHPI_Multi" 7"Other_Single" 8"Other_Multi"
r; t=0.00 4:54:30

. numlabel `new', mask(#) add
r; t=2.44 4:54:33

. label value `new' `new'
r; t=0.01 4:54:33

. note `new': Refer to `vold' | `tag'
r; t=0.00 4:54:33

. 
. 
. local new "praceethnicgp_multi_simplest" //Note that I force those who respond
> ed to race question but not Hispanic question to be either Black, NHPI, or oth
> er
r; t=0.00 4:54:33

. local vold "praceethnicgp_multi"
r; t=0.00 4:54:33

. gen `new'=0 if `vold'==0
(112,850 missing values generated)
r; t=0.07 4:54:33

. replace `new'=1 if `vold'==1
(4,182 real changes made)
r; t=0.04 4:54:33

. replace `new'=2 if `vold'>=6 & `vold'<=7
(3,127 real changes made)
r; t=0.05 4:54:33

. replace `new'=3 if (`vold'>=2 & `vold'<=5) | (`vold'>=8 & `vold'<=9)
(92,879 real changes made)
r; t=0.07 4:54:33

. label var `new' "Racial/ethnic Group"
r; t=0.04 4:54:33

. label define `new' 0"nHWhite_Single" 1"nHwhite_Multi" 2"NHPI" 3"Other"
r; t=0.00 4:54:33

. numlabel `new', mask(#) add
r; t=2.43 4:54:36

. label value `new' `new'
r; t=0.00 4:54:36

. note `new': Refer to `vold' | `tag'
r; t=0.00 4:54:36

. 
. 
. 
. local new "hhincome"
r; t=0.00 4:54:36

. local old "income2"
r; t=0.00 4:54:36

. gen `new'=0 if `old'==1
(431,670 missing values generated)
r; t=0.07 4:54:36

. replace `new'=1 if `old'==2
(19,334 real changes made)
r; t=0.05 4:54:36

. replace `new'=2 if `old'==3
(27,735 real changes made)
r; t=0.05 4:54:36

. replace `new'=3 if `old'==4
(34,222 real changes made)
r; t=0.04 4:54:36

. replace `new'=4 if `old'==5
(39,751 real changes made)
r; t=0.04 4:54:36

. replace `new'=5 if `old'==6
(53,148 real changes made)
r; t=0.04 4:54:36

. replace `new'=6 if `old'==7
(59,632 real changes made)
r; t=0.04 4:54:36

. replace `new'=7 if `old'==8
(122,763 real changes made)
r; t=0.05 4:54:36

. label var `new' "Household Income"
r; t=0.00 4:54:36

. label define `new' 0"<10000" 1"10000-14999" 2"15000-19999" 3"20000-24999" 4"25
> 000-34999" 5"35000-49999" 6"50000-74999" 7"75000+"
r; t=0.00 4:54:36

. numlabel `new', mask(#_) add
r; t=2.70 4:54:39

. label value `new' `new'
r; t=0.01 4:54:39

. note `new': Original: `old' | `tag'
r; t=0.00 4:54:39

. 
. 
. local new "sexualorientation"
r; t=0.00 4:54:39

. local old "sxorient"
r; t=0.00 4:54:39

. gen `new'=`old'-1 if `old'<=4
(252,071 missing values generated)
r; t=0.09 4:54:39

. label var `new' "Sexual orientation"
r; t=0.00 4:54:39

. label define `new' 0"Heterosexual" 1"Homosexual" 2"Bisexual" 3"Other"
r; t=0.00 4:54:39

. numlabel `new', mask(#) add
r; t=2.57 4:54:41

. label value `new' `new'
r; t=0.00 4:54:41

. note `new': Original: `old' | `tag'
r; t=0.00 4:54:41

. 
. 
. local new "sexualorientation_sim"
r; t=0.00 4:54:41

. local old "sexualorientation"
r; t=0.00 4:54:41

. gen `new'=0 if `old'==0
(259,706 missing values generated)
r; t=0.07 4:54:41

. replace `new'=1 if `old'>=1 & `old'<=3
(7,635 real changes made)
r; t=0.05 4:54:41

. label var `new' "Sexual orientation"
r; t=0.00 4:54:41

. label define `new' 0"Heterosexual" 1"Other"
r; t=0.00 4:54:41

. numlabel `new', mask(#) add
r; t=2.70 4:54:44

. label value `new' `new'
r; t=0.01 4:54:44

. note `new': Original: `old' | `tag'
r; t=0.00 4:54:44

. 
. 
. 
. 
. *Technical variables
. local new "svyweight"
r; t=0.00 4:54:44

. local old "_llcpwt"
r; t=0.00 4:54:44

. gen `new'=`old'
r; t=0.05 4:54:44

. label var `new' "Survey weight"
r; t=0.00 4:54:44

. note `new': Original: `old' | `tag'
r; t=0.00 4:54:44

. 
. 
. local new "strata"
r; t=0.00 4:54:44

. local old "_ststr"
r; t=0.00 4:54:44

. gen `new'=`old'
r; t=0.04 4:54:44

. label var `new' "Strata"
r; t=0.00 4:54:44

. note `new': Original: `old' | `tag'
r; t=0.00 4:54:44

. 
. 
. local new "psu"
r; t=0.00 4:54:44

. local old "_psu"
r; t=0.00 4:54:44

. gen double `new'=`old'
r; t=0.05 4:54:44

. label var `new' "PSU"
r; t=0.00 4:54:44

. note `new': Original: `old' | `tag'
r; t=0.00 4:54:44

. 
. 
. local new "state"
r; t=0.00 4:54:44

. local old "_state"
r; t=0.00 4:54:44

. gen `new'=`old'
r; t=0.05 4:54:44

. label var `new' "State FIPS Code"
r; t=0.00 4:54:44

. note `new': Original: `old' | `tag'
r; t=0.00 4:54:44

. 
. 
. local new "month"
r; t=0.00 4:54:44

. local old "imonth"
r; t=0.00 4:54:44

. gen `new'=`old'
r; t=0.18 4:54:44

. label var `new' "Interview Month"
r; t=0.00 4:54:44

. note `new': Original: `old' | `tag'
r; t=0.00 4:54:44

. 
. 
. local new "year"
r; t=0.00 4:54:44

. local old "iyear"
r; t=0.00 4:54:44

. gen `new'=`old'
r; t=0.19 4:54:45

. label var `new' "Interview Year"
r; t=0.00 4:54:45

. note `new': Original: `old' | `tag'
r; t=0.00 4:54:45

. 
. 
. local new "interview_comp"
r; t=0.00 4:54:45

. local old "dispcode"
r; t=0.00 4:54:45

. gen `new'=0 if `old'==1200
(377,658 missing values generated)
r; t=0.06 4:54:45

. replace `new'=1 if `old'==1100
(377,658 real changes made)
r; t=0.06 4:54:45

. label var `new' "Interview Complete"
r; t=0.00 4:54:45

. label define `new' 0"PartialInterview" 1"CompletedInterview"
r; t=0.00 4:54:45

. numlabel `new', mask(#) add
r; t=1.82 4:54:47

. label value `new' `new'
r; t=0.01 4:54:47

. note `new': Original: `old' | `tag'
r; t=0.00 4:54:47

. 
. 
. local new "metrogroup"
r; t=0.00 4:54:47

. local old "mscode"
r; t=0.00 4:54:47

. gen `new'=0 if `old'==1
(390,689 missing values generated)
r; t=0.07 4:54:47

. replace `new'=1 if `old'==2
(34,700 real changes made)
r; t=0.04 4:54:47

. replace `new'=2 if `old'==3
(35,245 real changes made)
r; t=0.05 4:54:47

. replace `new'=3 if `old'==5
(62,484 real changes made)
r; t=0.05 4:54:47

. replace `new'=4 if `old'==.
(258,260 real changes made)
r; t=0.07 4:54:47

. label var `new' "Metropolitan Status Code"
r; t=0.00 4:54:47

. label define `new' 0"CenterCityinMSA" 1"OutsideCityInCounty" 2"SuburbanCounty"
>  3"OutsideMSA" 4"GU/PR/VI/Cell"
r; t=0.00 4:54:47

. numlabel `new', mask(#) add
r; t=2.85 4:54:50

. label value `new' `new'
r; t=0.01 4:54:50

. note `new': Original: `old' | `tag'
r; t=0.00 4:54:50

. 
. 
. 
. local new "censusdivision"
r; t=0.00 4:54:50

. local old "state"
r; t=0.00 4:54:50

. gen `new'=0 if `old'==9 | `old'==23 | `old'==25 | `old'==33 | `old'==44 | `old
> '==50
(404,925 missing values generated)
r; t=0.07 4:54:50

. replace `new'=1 if `old'==34 | `old'==36 | `old'==42
(30,510 real changes made)
r; t=0.04 4:54:50

. replace `new'=2 if `old'==17 | `old'==18 | `old'==26 | `old'==39 | `old'==55
(48,362 real changes made)
r; t=0.05 4:54:50

. replace `new'=3 if `old'==19 | `old'==20 | `old'==27 | `old'==29 | `old'==31 |
>  `old'==38 | `old'==46
(83,592 real changes made)
r; t=0.06 4:54:50

. replace `new'=4 if `old'==12 | `old'==13 | `old'==37 | `old'==45 | `old'==51 |
>  `old'==11 | `old'==24 | `old'==10 | `old'==54
(81,039 real changes made)
r; t=0.07 4:54:50

. replace `new'=5 if `old'==1  | `old'==21 | `old'==28 | `old'==47
(26,315 real changes made)
r; t=0.05 4:54:50

. replace `new'=6 if `old'==5 | `old'==22 | `old'==40 | `old'==48
(29,024 real changes made)
r; t=0.05 4:54:50

. replace `new'=7 if `old'==4 | `old'==8 | `old'==16 | `old'==30 | `old'==32 | `
> old'==35 | `old'==49 | `old'==56
(61,126 real changes made)
r; t=0.07 4:54:50

. replace `new'=8 if `old'==2 | `old'==6 | `old'==15 | `old'==41 | `old'==53
(38,964 real changes made)
r; t=0.06 4:54:50

. replace `new'=9 if `old'==66
(1,508 real changes made)
r; t=0.04 4:54:50

. replace `new'=10 if `old'==72
(4,485 real changes made)
r; t=0.04 4:54:50

. label var `new' "Census Division"
r; t=0.00 4:54:50

. label define `new' 0"NewEngland" 1"MidAtlantic" 2"ENCentral" 3"WNCentral" 4"SA
> tlantic" 5"ESCentral" 6"WSCentral" 7"Mountain" 8"Pacific" 9"Guam" 10"PuertoRic
> o"
r; t=0.00 4:54:50

. numlabel `new', mask(#) add
r; t=2.09 4:54:52

. label value `new' `new'
r; t=0.02 4:54:52

. note `new': Original: `old' | `tag'
r; t=0.00 4:54:52

. 
. 
. local new "censusregion"
r; t=0.00 4:54:52

. local old "censusdivision"
r; t=0.00 4:54:52

. gen `new'=0 if `old'>=0 & `old'<=1
(374,415 missing values generated)
r; t=0.05 4:54:52

. replace `new'=1 if `old'>=2 & `old'<=3
(131,954 real changes made)
r; t=0.05 4:54:53

. replace `new'=2 if `old'>=4 & `old'<=6
(136,378 real changes made)
r; t=0.05 4:54:53

. replace `new'=3 if `old'>=7 & `old'<=8
(100,090 real changes made)
r; t=0.04 4:54:53

. replace `new'=4 if `old'==9
(1,508 real changes made)
r; t=0.04 4:54:53

. replace `new'=5 if `old'==10
(4,485 real changes made)
r; t=0.04 4:54:53

. label var `new' "Census Region"
r; t=0.00 4:54:53

. label define `new' 0"Northeast" 1"MidWest" 2"South" 3"West" 4"Guam" 5"PuertoRi
> co"
r; t=0.00 4:54:53

. numlabel `new', mask(#) add
r; t=2.59 4:54:55

. label value `new' `new'
r; t=0.01 4:54:55

. note `new': Original: `old' | `tag'
r; t=0.00 4:54:55

. 
. 
. local new "censusregion_sim"
r; t=0.00 4:54:55

. local old "censusregion"
r; t=0.00 4:54:55

. gen `new'=0 if `old'>=0 & `old'<=2
(106,083 missing values generated)
r; t=0.07 4:54:55

. replace `new'=1 if `old'==3 & state!=15
(92,336 real changes made)
r; t=0.06 4:54:55

. replace `new'=2 if state==15 //Put Hawaii into a separate category
(7,754 real changes made)
r; t=0.04 4:54:55

. replace `new'=3 if `old'==4
(1,508 real changes made)
r; t=0.03 4:54:55

. replace `new'=4 if `old'==5
(4,485 real changes made)
r; t=0.05 4:54:56

. label var `new' "Census Region"
r; t=0.00 4:54:56

. label define `new' 0"Eastern" 1"West" 2"Hawaii" 3"Guam" 4"PuertoRico"
r; t=0.00 4:54:56

. numlabel `new', mask(#) add
r; t=1.100 4:54:58

. label value `new' `new'
r; t=0.01 4:54:58

. note `new': Original: `old' | `tag'
r; t=0.00 4:54:58

. 
. 
. 
. 
. 
. *For gsem estimation
. gen exe_intensity_sim_m=exe_intensity_sim if male==1
(269,106 missing values generated)
r; t=0.07 4:54:58

. gen exe_intensity_sim_f=exe_intensity_sim if male==0
(220,419 missing values generated)
r; t=1.03 4:54:59

. 
. gen exe_intensity_simplest_m=exe_intensity_simplest if male==1
(269,106 missing values generated)
r; t=0.09 4:54:59

. gen exe_intensity_simplest_f=exe_intensity_simplest if male==0
(220,419 missing values generated)
r; t=0.08 4:54:59

. 
. gen exe_aerobic_advice_m=exe_aerobic_advice if male==1
(273,461 missing values generated)
r; t=0.08 4:54:59

. gen exe_aerobic_advice_f=exe_aerobic_advice if male==0
(226,775 missing values generated)
r; t=0.07 4:54:59

. 
. gen exe_strength_advice_m=exe_strength_advice if male==1
(270,153 missing values generated)
r; t=0.07 4:54:59

. gen exe_strength_advice_f=exe_strength_advice if male==0
(221,522 missing values generated)
r; t=0.08 4:54:59

. 
. gen exe_active_m=exe_active if male==1
(274,415 missing values generated)
r; t=0.07 4:54:59

. gen exe_active_f=exe_active if male==0
(228,345 missing values generated)
r; t=0.08 4:54:59

. 
. 
. local dvlist exe_intensity_sim_m exe_intensity_sim_f exe_aerobic_advice_m exe_
> aerobic_advice_f
r; t=0.00 4:54:59

. local dvlist `dvlist' exe_strength_advice_m exe_strength_advice_f exe_active_m
>  exe_active_f exe_intensity_simplest_m exe_intensity_simplest_f
r; t=0.00 4:54:59

. foreach var in `dvlist' {
  2.         forvalues dvnum=1(1)20 {
  3.                 gen `var'`dvnum'=`var'
  4.         }
  5. }
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(273,461 missing values generated)
(273,461 missing values generated)
(273,461 missing values generated)
(273,461 missing values generated)
(273,461 missing values generated)
(273,461 missing values generated)
(273,461 missing values generated)
(273,461 missing values generated)
(273,461 missing values generated)
(273,461 missing values generated)
(273,461 missing values generated)
(273,461 missing values generated)
(273,461 missing values generated)
(273,461 missing values generated)
(273,461 missing values generated)
(273,461 missing values generated)
(273,461 missing values generated)
(273,461 missing values generated)
(273,461 missing values generated)
(273,461 missing values generated)
(226,775 missing values generated)
(226,775 missing values generated)
(226,775 missing values generated)
(226,775 missing values generated)
(226,775 missing values generated)
(226,775 missing values generated)
(226,775 missing values generated)
(226,775 missing values generated)
(226,775 missing values generated)
(226,775 missing values generated)
(226,775 missing values generated)
(226,775 missing values generated)
(226,775 missing values generated)
(226,775 missing values generated)
(226,775 missing values generated)
(226,775 missing values generated)
(226,775 missing values generated)
(226,775 missing values generated)
(226,775 missing values generated)
(226,775 missing values generated)
(270,153 missing values generated)
(270,153 missing values generated)
(270,153 missing values generated)
(270,153 missing values generated)
(270,153 missing values generated)
(270,153 missing values generated)
(270,153 missing values generated)
(270,153 missing values generated)
(270,153 missing values generated)
(270,153 missing values generated)
(270,153 missing values generated)
(270,153 missing values generated)
(270,153 missing values generated)
(270,153 missing values generated)
(270,153 missing values generated)
(270,153 missing values generated)
(270,153 missing values generated)
(270,153 missing values generated)
(270,153 missing values generated)
(270,153 missing values generated)
(221,522 missing values generated)
(221,522 missing values generated)
(221,522 missing values generated)
(221,522 missing values generated)
(221,522 missing values generated)
(221,522 missing values generated)
(221,522 missing values generated)
(221,522 missing values generated)
(221,522 missing values generated)
(221,522 missing values generated)
(221,522 missing values generated)
(221,522 missing values generated)
(221,522 missing values generated)
(221,522 missing values generated)
(221,522 missing values generated)
(221,522 missing values generated)
(221,522 missing values generated)
(221,522 missing values generated)
(221,522 missing values generated)
(221,522 missing values generated)
(274,415 missing values generated)
(274,415 missing values generated)
(274,415 missing values generated)
(274,415 missing values generated)
(274,415 missing values generated)
(274,415 missing values generated)
(274,415 missing values generated)
(274,415 missing values generated)
(274,415 missing values generated)
(274,415 missing values generated)
(274,415 missing values generated)
(274,415 missing values generated)
(274,415 missing values generated)
(274,415 missing values generated)
(274,415 missing values generated)
(274,415 missing values generated)
(274,415 missing values generated)
(274,415 missing values generated)
(274,415 missing values generated)
(274,415 missing values generated)
(228,345 missing values generated)
(228,345 missing values generated)
(228,345 missing values generated)
(228,345 missing values generated)
(228,345 missing values generated)
(228,345 missing values generated)
(228,345 missing values generated)
(228,345 missing values generated)
(228,345 missing values generated)
(228,345 missing values generated)
(228,345 missing values generated)
(228,345 missing values generated)
(228,345 missing values generated)
(228,345 missing values generated)
(228,345 missing values generated)
(228,345 missing values generated)
(228,345 missing values generated)
(228,345 missing values generated)
(228,345 missing values generated)
(228,345 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(269,106 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
(220,419 missing values generated)
r; t=13.21 4:55:13

. 
. /*
> *Generate census region-specific DV
> foreach var in `dvlist' {
>         local `var'_
>         forvalues dvnum=1(1)20 {
>                 gen `var'`dvnum'=`var'
>         }
> }
> */
. 
. *Generate outcomes by census region
. gen exe_intensity_sim_m_cr0=exe_intensity_sim_m if censusregion_sim==0
(313,316 missing values generated)
r; t=0.08 4:55:13

. gen exe_intensity_sim_m_cr1=exe_intensity_sim_m if censusregion_sim==1
(411,477 missing values generated)
r; t=0.06 4:55:13

. gen exe_intensity_sim_m_cr2=exe_intensity_sim_m if censusregion_sim==2
(446,673 missing values generated)
r; t=0.06 4:55:13

. gen exe_intensity_sim_m_cr3=exe_intensity_sim_m if censusregion_sim==3
(449,358 missing values generated)
r; t=0.06 4:55:13

. gen exe_intensity_sim_m_cr4=exe_intensity_sim_m if censusregion_sim==4
(448,346 missing values generated)
r; t=0.05 4:55:13

. 
. gen exe_intensity_sim_f_cr0=exe_intensity_sim_f if censusregion_sim==0
(272,928 missing values generated)
r; t=0.08 4:55:13

. gen exe_intensity_sim_f_cr1=exe_intensity_sim_f if censusregion_sim==1
(404,695 missing values generated)
r; t=0.06 4:55:13

. gen exe_intensity_sim_f_cr2=exe_intensity_sim_f if censusregion_sim==2
(446,272 missing values generated)
r; t=0.06 4:55:13

. gen exe_intensity_sim_f_cr3=exe_intensity_sim_f if censusregion_sim==3
(449,298 missing values generated)
r; t=0.05 4:55:13

. gen exe_intensity_sim_f_cr4=exe_intensity_sim_f if censusregion_sim==4
(447,290 missing values generated)
r; t=0.06 4:55:13

. 
. 
. gen exe_intensity_simplest_m_cr0=exe_intensity_simplest_m if censusregion_sim=
> =0
(313,316 missing values generated)
r; t=0.09 4:55:13

. gen exe_intensity_simplest_m_cr1=exe_intensity_simplest_m if censusregion_sim=
> =1
(411,477 missing values generated)
r; t=0.07 4:55:13

. gen exe_intensity_simplest_m_cr2=exe_intensity_simplest_m if censusregion_sim=
> =2
(446,673 missing values generated)
r; t=0.06 4:55:13

. gen exe_intensity_simplest_m_cr3=exe_intensity_simplest_m if censusregion_sim=
> =3
(449,358 missing values generated)
r; t=1.13 4:55:15

. gen exe_intensity_simplest_m_cr4=exe_intensity_simplest_m if censusregion_sim=
> =4
(448,346 missing values generated)
r; t=0.11 4:55:15

. 
. gen exe_intensity_simplest_f_cr0=exe_intensity_simplest_f if censusregion_sim=
> =0
(272,928 missing values generated)
r; t=0.12 4:55:15

. gen exe_intensity_simplest_f_cr1=exe_intensity_simplest_f if censusregion_sim=
> =1
(404,695 missing values generated)
r; t=0.09 4:55:15

. gen exe_intensity_simplest_f_cr2=exe_intensity_simplest_f if censusregion_sim=
> =2
(446,272 missing values generated)
r; t=0.08 4:55:15

. gen exe_intensity_simplest_f_cr3=exe_intensity_simplest_f if censusregion_sim=
> =3
(449,298 missing values generated)
r; t=0.08 4:55:15

. gen exe_intensity_simplest_f_cr4=exe_intensity_simplest_f if censusregion_sim=
> =4
(447,290 missing values generated)
r; t=0.08 4:55:15

. 
. 
. 
. 
. 
. gen exe_aerobic_advice_m_cr0=exe_aerobic_advice_m if censusregion_sim==0
(316,766 missing values generated)
r; t=0.11 4:55:15

. gen exe_aerobic_advice_m_cr1=exe_aerobic_advice_m if censusregion_sim==1
(412,294 missing values generated)
r; t=0.10 4:55:15

. gen exe_aerobic_advice_m_cr2=exe_aerobic_advice_m if censusregion_sim==2
(446,722 missing values generated)
r; t=0.10 4:55:15

. gen exe_aerobic_advice_m_cr3=exe_aerobic_advice_m if censusregion_sim==3
(449,370 missing values generated)
r; t=0.09 4:55:15

. gen exe_aerobic_advice_m_cr4=exe_aerobic_advice_m if censusregion_sim==4
(448,373 missing values generated)
r; t=0.09 4:55:16

. 
. gen exe_aerobic_advice_f_cr0=exe_aerobic_advice_f if censusregion_sim==0
(278,067 missing values generated)
r; t=0.12 4:55:16

. gen exe_aerobic_advice_f_cr1=exe_aerobic_advice_f if censusregion_sim==1
(405,801 missing values generated)
r; t=0.09 4:55:16

. gen exe_aerobic_advice_f_cr2=exe_aerobic_advice_f if censusregion_sim==2
(446,331 missing values generated)
r; t=0.08 4:55:16

. gen exe_aerobic_advice_f_cr3=exe_aerobic_advice_f if censusregion_sim==3
(449,311 missing values generated)
r; t=0.08 4:55:16

. gen exe_aerobic_advice_f_cr4=exe_aerobic_advice_f if censusregion_sim==4
(447,329 missing values generated)
r; t=0.08 4:55:16

. 
. gen exe_strength_advice_m_cr0=exe_strength_advice_m if censusregion_sim==0
(314,223 missing values generated)
r; t=0.13 4:55:16

. gen exe_strength_advice_m_cr1=exe_strength_advice_m if censusregion_sim==1
(411,622 missing values generated)
r; t=0.11 4:55:16

. gen exe_strength_advice_m_cr2=exe_strength_advice_m if censusregion_sim==2
(446,672 missing values generated)
r; t=0.10 4:55:16

. gen exe_strength_advice_m_cr3=exe_strength_advice_m if censusregion_sim==3
(449,367 missing values generated)
r; t=0.10 4:55:16

. gen exe_strength_advice_m_cr4=exe_strength_advice_m if censusregion_sim==4
(448,333 missing values generated)
r; t=0.10 4:55:17

. 
. gen exe_strength_advice_f_cr0=exe_strength_advice_f if censusregion_sim==0
(273,929 missing values generated)
r; t=0.12 4:55:17

. gen exe_strength_advice_f_cr1=exe_strength_advice_f if censusregion_sim==1
(404,806 missing values generated)
r; t=0.11 4:55:17

. gen exe_strength_advice_f_cr2=exe_strength_advice_f if censusregion_sim==2
(446,259 missing values generated)
r; t=0.10 4:55:17

. gen exe_strength_advice_f_cr3=exe_strength_advice_f if censusregion_sim==3
(449,304 missing values generated)
r; t=0.10 4:55:17

. gen exe_strength_advice_f_cr4=exe_strength_advice_f if censusregion_sim==4
(447,288 missing values generated)
r; t=0.10 4:55:17

. 
. 
. gen exe_active_m_cr0=exe_active_m if censusregion_sim==0
(317,495 missing values generated)
r; t=0.13 4:55:17

. gen exe_active_m_cr1=exe_active_m if censusregion_sim==1
(412,500 missing values generated)
r; t=0.11 4:55:17

. gen exe_active_m_cr2=exe_active_m if censusregion_sim==2
(446,734 missing values generated)
r; t=0.09 4:55:17

. gen exe_active_m_cr3=exe_active_m if censusregion_sim==3
(449,373 missing values generated)
r; t=0.08 4:55:17

. gen exe_active_m_cr4=exe_active_m if censusregion_sim==4
(448,377 missing values generated)
r; t=0.07 4:55:18

. 
. gen exe_active_f_cr0=exe_active_f if censusregion_sim==0
(279,304 missing values generated)
r; t=0.11 4:55:18

. gen exe_active_f_cr1=exe_active_f if censusregion_sim==1
(406,112 missing values generated)
r; t=0.10 4:55:18

. gen exe_active_f_cr2=exe_active_f if censusregion_sim==2
(446,350 missing values generated)
r; t=0.08 4:55:18

. gen exe_active_f_cr3=exe_active_f if censusregion_sim==3
(449,314 missing values generated)
r; t=0.09 4:55:18

. gen exe_active_f_cr4=exe_active_f if censusregion_sim==4
(447,329 missing values generated)
r; t=0.10 4:55:18

. 
. 
. 
. svyset [pweight=svyweight], strata(strata) psu(psu) singleunit(centered)

      pweight: svyweight
          VCE: linearized
  Single unit: centered
     Strata 1: strata
         SU 1: psu
        FPC 1: <zero>
r; t=0.02 4:55:18

. 
. 
. 
. drop if mi(male) //don't want to impute missing values of gender
(284 observations deleted)
r; t=0.65 4:55:19

. 
. gen id=_n //generate unique respondent's ID
r; t=0.05 4:55:19

. 
. 
. compress
  variable neighsafe was float now byte
  variable srh was float now byte
  variable badphyhlth was float now byte
  variable badmenhlth was float now byte
  variable actpoorhlth was float now byte
  variable asthmadiag was float now byte
  variable cholesteroldiag was float now byte
  variable heartattackdiag was float now byte
  variable heartdiseasediag was float now byte
  variable strokediag was float now byte
  variable diabetesdiag was float now byte
  variable highbloodpressurediag was float now byte
  variable actlim was float now byte
  variable walkdiff was float now byte
  variable dressdiff was float now byte
  variable erranddiffalone was float now byte
  variable funclimit was float now byte
  variable stress_days was float now byte
  variable bodycheck was float now byte
  variable bingedrink was float now byte
  variable heavydrink was float now byte
  variable smokeever was float now byte
  variable smoking was float now byte
  variable smokingsim was float now byte
  variable veg1perday was float now byte
  variable greenveg1perday was float now byte
  variable fries1perday was float now byte
  variable potato1perday was float now byte
  variable otherveg1perday was float now byte
  variable totalfruit1perday was float now byte
  variable fruitjuice1perday was float now byte
  variable fruit1perday was float now byte
  variable soda1perday was float now byte
  variable sweetbev1perday was float now byte
  variable anyflushot was float now byte
  variable seatbeltusage was float now byte
  variable bmicat was float now byte
  variable hivrisk was float now byte
  variable cantgetmorefood was float now byte
  variable balancedmeal was float now byte
  variable exercise was float now byte
  variable exercise1type was float now byte
  variable exercise1min was float now int
  variable exercise2type was float now byte
  variable exercise2min was float now int
  variable exe1_intensity was float now byte
  variable exe2_intensity was float now byte
  variable exe_intensity was float now byte
  variable exe_intensity_sim was float now byte
  variable exe_intensity_simplest was float now byte
  variable exe1_min_per_week was float now int
  variable exe2_min_per_week was float now int
  variable exe_active was float now byte
  variable exe_aerobic_advice was float now byte
  variable exe_strength_advice was float now byte
  variable exe_aero_strength_advice was float now byte
  variable metval1 was float now int
  variable metval2 was float now int
  variable metval_avg was float now int
  variable afforddoc was float now byte
  variable hlthcare was float now byte
  variable hlthcare1864 was float now byte
  variable yearsold was float now byte
  variable agegroup was float now byte
  variable agegroup_sim was float now byte
  variable educ was float now byte
  variable edu was float now byte
  variable employstatus_full was float now byte
  variable employstatus was float now byte
  variable male was float now byte
  variable hispanic was float now byte
  variable prace was float now byte
  variable praceethnicgpf was float now byte
  variable praceethnicgp was float now byte
  variable praceethnicgp_sim was float now byte
  variable mrace was float now byte
  variable mraceethnicgpf was float now byte
  variable mraceethnicgp was float now byte
  variable multiracial_mark was float now byte
  variable praceethnicgp_multi was float now byte
  variable praceethnicgp_multi_sim was float now byte
  variable praceethnicgp_multi_sim2 was float now byte
  variable praceethnicgp_multi_altsim was float now byte
  variable praceethnicgp_multi_simplest was float now byte
  variable hhincome was float now byte
  variable sexualorientation was float now byte
  variable sexualorientation_sim was float now byte
  variable state was float now byte
  variable interview_comp was float now byte
  variable metrogroup was float now byte
  variable censusdivision was float now byte
  variable censusregion was float now byte
  variable censusregion_sim was float now byte
  variable exe_intensity_sim_m was float now byte
  variable exe_intensity_sim_f was float now byte
  variable exe_intensity_simplest_m was float now byte
  variable exe_intensity_simplest_f was float now byte
  variable exe_aerobic_advice_m was float now byte
  variable exe_aerobic_advice_f was float now byte
  variable exe_strength_advice_m was float now byte
  variable exe_strength_advice_f was float now byte
  variable exe_active_m was float now byte
  variable exe_active_f was float now byte
  variable exe_intensity_sim_m1 was float now byte
  variable exe_intensity_sim_m2 was float now byte
  variable exe_intensity_sim_m3 was float now byte
  variable exe_intensity_sim_m4 was float now byte
  variable exe_intensity_sim_m5 was float now byte
  variable exe_intensity_sim_m6 was float now byte
  variable exe_intensity_sim_m7 was float now byte
  variable exe_intensity_sim_m8 was float now byte
  variable exe_intensity_sim_m9 was float now byte
  variable exe_intensity_sim_m10 was float now byte
  variable exe_intensity_sim_m11 was float now byte
  variable exe_intensity_sim_m12 was float now byte
  variable exe_intensity_sim_m13 was float now byte
  variable exe_intensity_sim_m14 was float now byte
  variable exe_intensity_sim_m15 was float now byte
  variable exe_intensity_sim_m16 was float now byte
  variable exe_intensity_sim_m17 was float now byte
  variable exe_intensity_sim_m18 was float now byte
  variable exe_intensity_sim_m19 was float now byte
  variable exe_intensity_sim_m20 was float now byte
  variable exe_intensity_sim_f1 was float now byte
  variable exe_intensity_sim_f2 was float now byte
  variable exe_intensity_sim_f3 was float now byte
  variable exe_intensity_sim_f4 was float now byte
  variable exe_intensity_sim_f5 was float now byte
  variable exe_intensity_sim_f6 was float now byte
  variable exe_intensity_sim_f7 was float now byte
  variable exe_intensity_sim_f8 was float now byte
  variable exe_intensity_sim_f9 was float now byte
  variable exe_intensity_sim_f10 was float now byte
  variable exe_intensity_sim_f11 was float now byte
  variable exe_intensity_sim_f12 was float now byte
  variable exe_intensity_sim_f13 was float now byte
  variable exe_intensity_sim_f14 was float now byte
  variable exe_intensity_sim_f15 was float now byte
  variable exe_intensity_sim_f16 was float now byte
  variable exe_intensity_sim_f17 was float now byte
  variable exe_intensity_sim_f18 was float now byte
  variable exe_intensity_sim_f19 was float now byte
  variable exe_intensity_sim_f20 was float now byte
  variable exe_aerobic_advice_m1 was float now byte
  variable exe_aerobic_advice_m2 was float now byte
  variable exe_aerobic_advice_m3 was float now byte
  variable exe_aerobic_advice_m4 was float now byte
  variable exe_aerobic_advice_m5 was float now byte
  variable exe_aerobic_advice_m6 was float now byte
  variable exe_aerobic_advice_m7 was float now byte
  variable exe_aerobic_advice_m8 was float now byte
  variable exe_aerobic_advice_m9 was float now byte
  variable exe_aerobic_advice_m10 was float now byte
  variable exe_aerobic_advice_m11 was float now byte
  variable exe_aerobic_advice_m12 was float now byte
  variable exe_aerobic_advice_m13 was float now byte
  variable exe_aerobic_advice_m14 was float now byte
  variable exe_aerobic_advice_m15 was float now byte
  variable exe_aerobic_advice_m16 was float now byte
  variable exe_aerobic_advice_m17 was float now byte
  variable exe_aerobic_advice_m18 was float now byte
  variable exe_aerobic_advice_m19 was float now byte
  variable exe_aerobic_advice_m20 was float now byte
  variable exe_aerobic_advice_f1 was float now byte
  variable exe_aerobic_advice_f2 was float now byte
  variable exe_aerobic_advice_f3 was float now byte
  variable exe_aerobic_advice_f4 was float now byte
  variable exe_aerobic_advice_f5 was float now byte
  variable exe_aerobic_advice_f6 was float now byte
  variable exe_aerobic_advice_f7 was float now byte
  variable exe_aerobic_advice_f8 was float now byte
  variable exe_aerobic_advice_f9 was float now byte
  variable exe_aerobic_advice_f10 was float now byte
  variable exe_aerobic_advice_f11 was float now byte
  variable exe_aerobic_advice_f12 was float now byte
  variable exe_aerobic_advice_f13 was float now byte
  variable exe_aerobic_advice_f14 was float now byte
  variable exe_aerobic_advice_f15 was float now byte
  variable exe_aerobic_advice_f16 was float now byte
  variable exe_aerobic_advice_f17 was float now byte
  variable exe_aerobic_advice_f18 was float now byte
  variable exe_aerobic_advice_f19 was float now byte
  variable exe_aerobic_advice_f20 was float now byte
  variable exe_strength_advice_m1 was float now byte
  variable exe_strength_advice_m2 was float now byte
  variable exe_strength_advice_m3 was float now byte
  variable exe_strength_advice_m4 was float now byte
  variable exe_strength_advice_m5 was float now byte
  variable exe_strength_advice_m6 was float now byte
  variable exe_strength_advice_m7 was float now byte
  variable exe_strength_advice_m8 was float now byte
  variable exe_strength_advice_m9 was float now byte
  variable exe_strength_advice_m10 was float now byte
  variable exe_strength_advice_m11 was float now byte
  variable exe_strength_advice_m12 was float now byte
  variable exe_strength_advice_m13 was float now byte
  variable exe_strength_advice_m14 was float now byte
  variable exe_strength_advice_m15 was float now byte
  variable exe_strength_advice_m16 was float now byte
  variable exe_strength_advice_m17 was float now byte
  variable exe_strength_advice_m18 was float now byte
  variable exe_strength_advice_m19 was float now byte
  variable exe_strength_advice_m20 was float now byte
  variable exe_strength_advice_f1 was float now byte
  variable exe_strength_advice_f2 was float now byte
  variable exe_strength_advice_f3 was float now byte
  variable exe_strength_advice_f4 was float now byte
  variable exe_strength_advice_f5 was float now byte
  variable exe_strength_advice_f6 was float now byte
  variable exe_strength_advice_f7 was float now byte
  variable exe_strength_advice_f8 was float now byte
  variable exe_strength_advice_f9 was float now byte
  variable exe_strength_advice_f10 was float now byte
  variable exe_strength_advice_f11 was float now byte
  variable exe_strength_advice_f12 was float now byte
  variable exe_strength_advice_f13 was float now byte
  variable exe_strength_advice_f14 was float now byte
  variable exe_strength_advice_f15 was float now byte
  variable exe_strength_advice_f16 was float now byte
  variable exe_strength_advice_f17 was float now byte
  variable exe_strength_advice_f18 was float now byte
  variable exe_strength_advice_f19 was float now byte
  variable exe_strength_advice_f20 was float now byte
  variable exe_active_m1 was float now byte
  variable exe_active_m2 was float now byte
  variable exe_active_m3 was float now byte
  variable exe_active_m4 was float now byte
  variable exe_active_m5 was float now byte
  variable exe_active_m6 was float now byte
  variable exe_active_m7 was float now byte
  variable exe_active_m8 was float now byte
  variable exe_active_m9 was float now byte
  variable exe_active_m10 was float now byte
  variable exe_active_m11 was float now byte
  variable exe_active_m12 was float now byte
  variable exe_active_m13 was float now byte
  variable exe_active_m14 was float now byte
  variable exe_active_m15 was float now byte
  variable exe_active_m16 was float now byte
  variable exe_active_m17 was float now byte
  variable exe_active_m18 was float now byte
  variable exe_active_m19 was float now byte
  variable exe_active_m20 was float now byte
  variable exe_active_f1 was float now byte
  variable exe_active_f2 was float now byte
  variable exe_active_f3 was float now byte
  variable exe_active_f4 was float now byte
  variable exe_active_f5 was float now byte
  variable exe_active_f6 was float now byte
  variable exe_active_f7 was float now byte
  variable exe_active_f8 was float now byte
  variable exe_active_f9 was float now byte
  variable exe_active_f10 was float now byte
  variable exe_active_f11 was float now byte
  variable exe_active_f12 was float now byte
  variable exe_active_f13 was float now byte
  variable exe_active_f14 was float now byte
  variable exe_active_f15 was float now byte
  variable exe_active_f16 was float now byte
  variable exe_active_f17 was float now byte
  variable exe_active_f18 was float now byte
  variable exe_active_f19 was float now byte
  variable exe_active_f20 was float now byte
  variable exe_intensity_simplest_m1 was float now byte
  variable exe_intensity_simplest_m2 was float now byte
  variable exe_intensity_simplest_m3 was float now byte
  variable exe_intensity_simplest_m4 was float now byte
  variable exe_intensity_simplest_m5 was float now byte
  variable exe_intensity_simplest_m6 was float now byte
  variable exe_intensity_simplest_m7 was float now byte
  variable exe_intensity_simplest_m8 was float now byte
  variable exe_intensity_simplest_m9 was float now byte
  variable exe_intensity_simplest_m10 was float now byte
  variable exe_intensity_simplest_m11 was float now byte
  variable exe_intensity_simplest_m12 was float now byte
  variable exe_intensity_simplest_m13 was float now byte
  variable exe_intensity_simplest_m14 was float now byte
  variable exe_intensity_simplest_m15 was float now byte
  variable exe_intensity_simplest_m16 was float now byte
  variable exe_intensity_simplest_m17 was float now byte
  variable exe_intensity_simplest_m18 was float now byte
  variable exe_intensity_simplest_m19 was float now byte
  variable exe_intensity_simplest_m20 was float now byte
  variable exe_intensity_simplest_f1 was float now byte
  variable exe_intensity_simplest_f2 was float now byte
  variable exe_intensity_simplest_f3 was float now byte
  variable exe_intensity_simplest_f4 was float now byte
  variable exe_intensity_simplest_f5 was float now byte
  variable exe_intensity_simplest_f6 was float now byte
  variable exe_intensity_simplest_f7 was float now byte
  variable exe_intensity_simplest_f8 was float now byte
  variable exe_intensity_simplest_f9 was float now byte
  variable exe_intensity_simplest_f10 was float now byte
  variable exe_intensity_simplest_f11 was float now byte
  variable exe_intensity_simplest_f12 was float now byte
  variable exe_intensity_simplest_f13 was float now byte
  variable exe_intensity_simplest_f14 was float now byte
  variable exe_intensity_simplest_f15 was float now byte
  variable exe_intensity_simplest_f16 was float now byte
  variable exe_intensity_simplest_f17 was float now byte
  variable exe_intensity_simplest_f18 was float now byte
  variable exe_intensity_simplest_f19 was float now byte
  variable exe_intensity_simplest_f20 was float now byte
  variable exe_intensity_sim_m_cr0 was float now byte
  variable exe_intensity_sim_m_cr1 was float now byte
  variable exe_intensity_sim_m_cr2 was float now byte
  variable exe_intensity_sim_m_cr3 was float now byte
  variable exe_intensity_sim_m_cr4 was float now byte
  variable exe_intensity_sim_f_cr0 was float now byte
  variable exe_intensity_sim_f_cr1 was float now byte
  variable exe_intensity_sim_f_cr2 was float now byte
  variable exe_intensity_sim_f_cr3 was float now byte
  variable exe_intensity_sim_f_cr4 was float now byte
  variable exe_intensity_simplest_m_cr0 was float now byte
  variable exe_intensity_simplest_m_cr1 was float now byte
  variable exe_intensity_simplest_m_cr2 was float now byte
  variable exe_intensity_simplest_m_cr3 was float now byte
  variable exe_intensity_simplest_m_cr4 was float now byte
  variable exe_intensity_simplest_f_cr0 was float now byte
  variable exe_intensity_simplest_f_cr1 was float now byte
  variable exe_intensity_simplest_f_cr2 was float now byte
  variable exe_intensity_simplest_f_cr3 was float now byte
  variable exe_intensity_simplest_f_cr4 was float now byte
  variable exe_aerobic_advice_m_cr0 was float now byte
  variable exe_aerobic_advice_m_cr1 was float now byte
  variable exe_aerobic_advice_m_cr2 was float now byte
  variable exe_aerobic_advice_m_cr3 was float now byte
  variable exe_aerobic_advice_m_cr4 was float now byte
  variable exe_aerobic_advice_f_cr0 was float now byte
  variable exe_aerobic_advice_f_cr1 was float now byte
  variable exe_aerobic_advice_f_cr2 was float now byte
  variable exe_aerobic_advice_f_cr3 was float now byte
  variable exe_aerobic_advice_f_cr4 was float now byte
  variable exe_strength_advice_m_cr0 was float now byte
  variable exe_strength_advice_m_cr1 was float now byte
  variable exe_strength_advice_m_cr2 was float now byte
  variable exe_strength_advice_m_cr3 was float now byte
  variable exe_strength_advice_m_cr4 was float now byte
  variable exe_strength_advice_f_cr0 was float now byte
  variable exe_strength_advice_f_cr1 was float now byte
  variable exe_strength_advice_f_cr2 was float now byte
  variable exe_strength_advice_f_cr3 was float now byte
  variable exe_strength_advice_f_cr4 was float now byte
  variable exe_active_m_cr0 was float now byte
  variable exe_active_m_cr1 was float now byte
  variable exe_active_m_cr2 was float now byte
  variable exe_active_m_cr3 was float now byte
  variable exe_active_m_cr4 was float now byte
  variable exe_active_f_cr0 was float now byte
  variable exe_active_f_cr1 was float now byte
  variable exe_active_f_cr2 was float now byte
  variable exe_active_f_cr3 was float now byte
  variable exe_active_f_cr4 was float now byte
  variable _state was double now byte
  variable fmonth was double now byte
  variable dispcode was double now int
  variable _psu was double now long
  variable ctelenm1 was double now byte
  variable pvtresd1 was double now byte
  variable colghous was double now byte
  variable statere1 was double now byte
  variable cellfon4 was double now byte
  variable ladult was double now byte
  variable numadult was double now byte
  variable nummen was double now byte
  variable numwomen was double now byte
  variable safetime was double now byte
  variable ctelnum1 was double now byte
  variable cellfon5 was double now byte
  variable cadult was double now byte
  variable pvtresd3 was double now byte
  variable cclghous was double now byte
  variable cstate1 was double now byte
  variable landline was double now byte
  variable hhadult was double now byte
  variable genhlth was double now byte
  variable physhlth was double now byte
  variable menthlth was double now byte
  variable poorhlth was double now byte
  variable hlthpln1 was double now byte
  variable persdoc2 was double now byte
  variable medcost was double now byte
  variable checkup1 was double now byte
  variable bphigh4 was double now byte
  variable bpmeds was double now byte
  variable cholchk1 was double now byte
  variable toldhi2 was double now byte
  variable cholmed1 was double now byte
  variable cvdinfr4 was double now byte
  variable cvdcrhd4 was double now byte
  variable cvdstrk3 was double now byte
  variable asthma3 was double now byte
  variable asthnow was double now byte
  variable chcscncr was double now byte
  variable chcocncr was double now byte
  variable chccopd1 was double now byte
  variable havarth3 was double now byte
  variable addepev2 was double now byte
  variable chckidny was double now byte
  variable diabete3 was double now byte
  variable diabage2 was double now byte
  variable lmtjoin3 was double now byte
  variable arthdis2 was double now byte
  variable arthsocl was double now byte
  variable joinpai1 was double now byte
  variable sex was double now byte
  variable marital was double now byte
  variable educa was double now byte
  variable renthom1 was double now byte
  variable numhhol2 was double now byte
  variable numphon2 was double now byte
  variable cpdemo1a was double now byte
  variable veteran3 was double now byte
  variable employ1 was double now byte
  variable children was double now byte
  variable income2 was double now byte
  variable internet was double now byte
  variable weight2 was double now int
  variable height3 was double now int
  variable pregnant was double now byte
  variable deaf was double now byte
  variable blind was double now byte
  variable decide was double now byte
  variable diffwalk was double now byte
  variable diffdres was double now byte
  variable diffalon was double now byte
  variable smoke100 was double now byte
  variable smokday2 was double now byte
  variable stopsmk2 was double now byte
  variable lastsmk2 was double now byte
  variable usenow3 was double now byte
  variable ecigaret was double now byte
  variable ecignow was double now byte
  variable alcday5 was double now int
  variable avedrnk2 was double now byte
  variable drnk3ge5 was double now byte
  variable maxdrnks was double now byte
  variable fruit2 was double now int
  variable fruitju2 was double now int
  variable fvgreen1 was double now int
  variable frenchf1 was double now int
  variable potatoe1 was double now int
  variable vegetab2 was double now int
  variable exerany2 was double now byte
  variable exract11 was double now byte
  variable exeroft1 was double now int
  variable exerhmm1 was double now int
  variable exract21 was double now byte
  variable exeroft2 was double now int
  variable exerhmm2 was double now int
  variable strength was double now int
  variable seatbelt was double now byte
  variable flushot6 was double now byte
  variable flshtmy2 was double now long
  variable pneuvac3 was double now byte
  variable shingle2 was double now byte
  variable hivtst6 was double now byte
  variable hivtstd3 was double now long
  variable hivrisk5 was double now byte
  variable pdiabtst was double now byte
  variable prediab1 was double now byte
  variable insulin was double now byte
  variable bldsugar was double now int
  variable feetchk2 was double now int
  variable doctdiab was double now byte
  variable chkhemo3 was double now byte
  variable feetchk was double now byte
  variable eyeexam was double now byte
  variable diabeye was double now byte
  variable diabedu was double now byte
  variable copdcogh was double now byte
  variable copdflem was double now byte
  variable copdbrth was double now byte
  variable copdbtst was double now byte
  variable copdsmok was double now byte
  variable harehab1 was double now byte
  variable strehab1 was double now byte
  variable cvdasprn was double now byte
  variable aspunsaf was double now byte
  variable rlivpain was double now byte
  variable rduchart was double now byte
  variable rducstrk was double now byte
  variable bpeathbt was double now byte
  variable bpsalt was double now byte
  variable bpalchol was double now byte
  variable bpexer was double now byte
  variable bpeatadv was double now byte
  variable bpsltadv was double now byte
  variable bpalcadv was double now byte
  variable bpexradv was double now byte
  variable bpmedadv was double now byte
  variable bphi2mr was double now byte
  variable arttoday was double now byte
  variable arthwgt was double now byte
  variable arthexer was double now byte
  variable arthedu was double now byte
  variable asthmage was double now byte
  variable asattack was double now byte
  variable aservist was double now byte
  variable asdrvist was double now byte
  variable asrchkup was double now byte
  variable asactlim was double now int
  variable asymptom was double now byte
  variable asnoslep was double now byte
  variable asthmed3 was double now byte
  variable asinhalr was double now byte
  variable painact2 was double now byte
  variable qlmentl2 was double now byte
  variable qlstres2 was double now byte
  variable qlhlth2 was double now byte
  variable sleptim1 was double now byte
  variable adsleep was double now byte
  variable slepday1 was double now byte
  variable slepsno2 was double now byte
  variable slepbrth was double now byte
  variable medicare was double now byte
  variable hlthcvr1 was double now byte
  variable delaymed was double now byte
  variable nocov121 was double now byte
  variable lstcovrg was double now byte
  variable drvisits was double now byte
  variable medscos1 was double now byte
  variable carercvd was double now byte
  variable medbill1 was double now byte
  variable asbialch was double now byte
  variable asbidrnk was double now byte
  variable asbibing was double now byte
  variable asbiadvc was double now byte
  variable asbirduc was double now byte
  variable cncrdiff was double now byte
  variable cncrage was double now byte
  variable cncrtyp1 was double now byte
  variable csrvtrt2 was double now byte
  variable csrvdoc1 was double now byte
  variable csrvsum was double now byte
  variable csrvrtrn was double now byte
  variable csrvinst was double now byte
  variable csrvinsr was double now byte
  variable csrvdein was double now byte
  variable csrvclin was double now byte
  variable csrvpain was double now byte
  variable csrvctl1 was double now byte
  variable ssbsugr2 was double now int
  variable ssbfrut3 was double now int
  variable wtchsalt was double now byte
  variable dradvise was double now byte
  variable marijana was double now byte
  variable usemrjn1 was double now byte
  variable rsnmrjna was double now byte
  variable pfpprvn2 was double now byte
  variable typcntr7 was double now byte
  variable nobcuse6 was double now byte
  variable imfvplac was double now byte
  variable hpvadvc2 was double now byte
  variable hpvadsht was double now byte
  variable tetanus was double now byte
  variable lcsfirst was double now int
  variable lcslast was double now int
  variable lcsnumcg was double now int
  variable lcsctscn was double now byte
  variable caregiv1 was double now byte
  variable crgvrel2 was double now byte
  variable crgvlng1 was double now byte
  variable crgvhrs1 was double now byte
  variable crgvprb2 was double now byte
  variable crgvpers was double now byte
  variable crgvhous was double now byte
  variable crgvmst2 was double now byte
  variable crgvexpt was double now byte
  variable cimemlos was double now byte
  variable cdhouse was double now byte
  variable cdassist was double now byte
  variable cdhelp was double now byte
  variable cdsocial was double now byte
  variable cddiscus was double now byte
  variable emtsuprt was double now byte
  variable lsatisfy was double now byte
  variable sdhbills was double now byte
  variable sdhmove was double now byte
  variable howsafe1 was double now byte
  variable sdhfood was double now byte
  variable sdhmeals was double now byte
  variable sdhmoney was double now byte
  variable sdhstres was double now byte
  variable sxorient was double now byte
  variable trnsgndr was double now byte
  variable firearm4 was double now byte
  variable gunload was double now byte
  variable loadulk2 was double now byte
  variable rcsgendr was double now byte
  variable rcsrltn2 was double now byte
  variable casthdx2 was double now byte
  variable casthno2 was double now byte
  variable qstver was double now byte
  variable qstlang was double now byte
  variable mscode was double now byte
  variable _ststr was double now long
  variable _imprace was double now byte
  variable _chispnc was double now byte
  variable _crace1 was double now byte
  variable _cprace was double now byte
  variable _dualuse was double now byte
  variable _rfhlth was double now byte
  variable _phys14d was double now byte
  variable _ment14d was double now byte
  variable _hcvu651 was double now byte
  variable _rfhype5 was double now byte
  variable _cholch1 was double now byte
  variable _rfchol1 was double now byte
  variable _michd was double now byte
  variable _ltasth1 was double now byte
  variable _casthm1 was double now byte
  variable _asthms1 was double now byte
  variable _drdxar1 was double now byte
  variable _lmtact1 was double now byte
  variable _lmtwrk1 was double now byte
  variable _lmtscl1 was double now byte
  variable _prace1 was double now byte
  variable _mrace1 was double now byte
  variable _hispanc was double now byte
  variable _race was double now byte
  variable _raceg21 was double now byte
  variable _racegr3 was double now byte
  variable _race_g1 was double now byte
  variable _ageg5yr was double now byte
  variable _age65yr was double now byte
  variable _age80 was double now byte
  variable _age_g was double now byte
  variable htin4 was double now byte
  variable htm4 was double now int
  variable wtkg3 was double now int
  variable _bmi5 was double now int
  variable _bmi5cat was double now byte
  variable _rfbmi5 was double now byte
  variable _chldcnt was double now byte
  variable _educag was double now byte
  variable _incomg was double now byte
  variable _smoker3 was double now byte
  variable _rfsmok3 was double now byte
  variable _ecigsts was double now byte
  variable _curecig was double now byte
  variable drnkany5 was double now byte
  variable drocdy3_ was double now int
  variable _rfbing5 was double now byte
  variable _drnkwek was double now long
  variable _rfdrhv5 was double now byte
  variable ftjuda2_ was double now int
  variable frutda2_ was double now int
  variable grenda1_ was double now int
  variable frnchda_ was double now int
  variable potada1_ was double now int
  variable vegeda2_ was double now int
  variable _misfrt1 was double now byte
  variable _misveg1 was double now byte
  variable _frtres1 was double now byte
  variable _vegres1 was double now byte
  variable _frutsu1 was double now int
  variable _vegesu1 was double now int
  variable _frtlt1a was double now byte
  variable _veglt1a was double now byte
  variable _frt16a was double now byte
  variable _veg23a was double now byte
  variable _fruite1 was double now byte
  variable _vegete1 was double now byte
  variable _totinda was double now byte
  variable metvl11_ was double now int
  variable metvl21_ was double now int
  variable actin11_ was double now byte
  variable actin21_ was double now byte
  variable padur1_ was double now int
  variable padur2_ was double now int
  variable _minac11 was double now long
  variable _minac21 was double now long
  variable strfreq_ was double now long
  variable pamiss1_ was double now byte
  variable pamin11_ was double now long
  variable pamin21_ was double now long
  variable pa1min_ was double now long
  variable pavig11_ was double now long
  variable pavig21_ was double now long
  variable pa1vigm_ was double now long
  variable _pacat1 was double now byte
  variable _paindx1 was double now byte
  variable _pa150r2 was double now byte
  variable _pa300r2 was double now byte
  variable _pa30021 was double now byte
  variable _pastrng was double now byte
  variable _parec1 was double now byte
  variable _pastae1 was double now byte
  variable _rfseat2 was double now byte
  variable _rfseat3 was double now byte
  variable _flshot6 was double now byte
  variable _pneumo2 was double now byte
  variable _aidtst3 was double now byte
  variable psu was double now long
  (1,511,998,984 bytes saved)
r; t=421.57 5:02:20

. 
. 
. save "Data Ready for Analysis/brfss2017-readyforanalysis.dta",replace
file Data Ready for Analysis/brfss2017-readyforanalysis.dta saved
r; t=0.39 5:02:21

. 
. 
. *Ouput data for multiple imputation
. drop if state==72 //delete Puerto Rico
(4,484 observations deleted)
r; t=0.08 5:02:21

. 
. keep id svyweight strata psu /// technical variables
> exercise exercise1type exercise1freq exercise1min exercise2type exercise2freq 
> exercise2min muscleexercise exe1_intensity exe2_intensity exe_intensity_simple
> st exe_aerobic_advice exe_strength_advice exe_active /// physical activities
> state yearsold male educ hhincome praceethnicgp_multi_sim ///
> srh badphyhlth badmenhlth bmicat employstatus_full //auxiliary variables
r; t=0.10 5:02:21

. 
. save "Data Ready for Analysis/brfss2017-readyforimpute.dta",replace
file Data Ready for Analysis/brfss2017-readyforimpute.dta saved
r; t=0.10 5:02:21

. 
. 
. 
. *Ouput data for listwise analysis
. use "Data Ready for Analysis/brfss2017-readyforanalysis.dta",clear
r; t=0.25 5:02:21

. 
. keep svyweight strata psu /// technical variables
> exe_aerobic_advice_m* exe_strength_advice_m* exe_aerobic_advice_f* exe_strengt
> h_advice_f* state yearsold year praceethnicgp_multi_sim male educ hhincome exe
> _aerobic_advice_m_cr* exe_strength_advice_m_cr* exe_aerobic_advice_f_cr* exe_s
> trength_advice_f_cr*
r; t=0.12 5:02:21

. save "Data Ready for Analysis/brfss2017-readyforlistwiseanalysis.dta",replace
file Data Ready for Analysis/brfss2017-readyforlistwiseanalysis.dta saved
r; t=0.14 5:02:22

. 
. 
. 
. 
. *save `pgm'.dta,replace
. 
. *estwrite * using `pgm',replace
. 
. 
. log close
      name:  <unnamed>
       log:  C:\Users\Yanan and Ben\Desktop\NHPI-exercise Replication Package\20
> 250822-brfss2017-dataprep.log
  log type:  text
 closed on:  25 Aug 2025, 05:02:22
--------------------------------------------------------------------------------
